{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Result NAAC","Result KeyFactorwise NAAC","Input","Result KeyFactorwise","Result"],"not_rendered":{"macros":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Result NAAC","index":0,"n_rows":16,"n_cols":19,"rows_kept":16,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5],[12,1,12,2]]}
[null,"SHRI SHIV CHARAN MATHUR, GOVERNMENT COLLEGE, MANDALGARH",{"$nulls":15},0,"D"]
[null,"Assessment Matrix for Annual Auditing Programe",{"$nulls":15},1.5,"D"]
[null,"Session : 2019-20",{"$nulls":15},1.5001,"C"]
[null,"Performance Criteria","Weights","Criteria-wise Grade Points","Criteria-wise Grade Points Averages","Crietria-wise Grade",{"$nulls":3},"Delete Input Values",{"$nulls":7},2,"C"]
[null,{"$f":"+Input!A7","v":"A. Teaching and Learning"},{"$f":"SUM(Input!I7:I37)","v":{"v":35,"d":"35.00"}},{"$f":"SUM('Result KeyFactorwise'!D5:D9)","v":{"v":49.5,"d":"49.50"}},{"$f":"IF(C5=\"\",\"\",ROUND(D5/C5,3))","v":{"v":1.414,"d":"1.4140"}},{"$f":"IF(E5=0,\"D\",VLOOKUP(E5,$R$1:$S$16,2))","v":"D"},{"$nulls":3},"A",{"$nulls":7},2.001,"B"]
[null,{"$f":"+Input!A38","v":"B. Research and Professional Practices"},{"$f":"SUM(Input!I38:I50)","v":{"v":15,"d":"15.00"}},{"$f":"SUM('Result KeyFactorwise'!D10:D11)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C6=\"\",\"\",ROUND(D6/C6,3))","v":{"v":0,"d":"0.0000"}},"D",{"$nulls":3},"B",{"$nulls":7},2.5,"B"]
[null,{"$f":"+Input!A51","v":"C. Infrastructure and Learning Resources"},{"$f":"SUM(Input!I51:I74)","v":{"v":15,"d":"15.00"}},{"$f":"SUM('Result KeyFactorwise'!D12:D13)","v":{"v":43.5,"d":"43.50"}},{"v":2.9,"d":"2.9000"},"B++",{"$nulls":3},"C",{"$nulls":7},2.5001,"B+"]
[null,{"$f":"+Input!A75","v":"D. Student Support and participation"},{"$f":"SUM(Input!I75:I107)","v":{"v":10,"d":"10.00"}},{"$f":"SUM('Result KeyFactorwise'!D14:D15)","v":17.25},{"v":1.725,"d":"1.7250"},"C",{"$nulls":3},"D",{"$nulls":7},2.75,"B+"]
[null,{"$f":"+Input!A108","v":"E. Financial Resources and Utilisation"},{"$f":"SUM(Input!I108:I112)","v":{"v":10,"d":"10.00"}},{"$f":"SUM('Result KeyFactorwise'!D16:D17)","v":{"v":10,"d":"10.00"}},{"v":1,"d":"1.0000"},"D",{"$nulls":3},"E",{"$nulls":7},2.7501,"B++"]
[null,{"$f":"+Input!A113","v":"F. Commitment, Leadership and Management"},{"$f":"SUM(Input!I113:I137)","v":{"v":15,"d":"15.00"}},{"$f":"SUM('Result KeyFactorwise'!D18:D21)","v":{"v":29,"d":"29.00"}},{"v":1.933,"d":"1.9330"},"C",{"$nulls":3},"F",{"$nulls":7},3,"B++"]
[null,"TOTAL",{"$f":"IF(SUM(C5:C10)=0,\"\",SUM(C5:C10))","v":{"v":100,"d":"100.00"}},{"$f":"IF(SUM(D5:D10)=0,\"\",SUM(D5:D10))","v":149.25},{"$f":"IF(SUM(E5:E10)=0,\"\",SUM(E5:E10))","v":{"v":8.972,"d":"8.9720"}},{"$nulls":12},3.001,"A"]
[{"$nulls":17},3.25,"A"]
[null,{"$f":"IF(D13=\"\",\"\",\"Institutional CGPA & GRADE\")","v":"Institutional CGPA & GRADE"},null,{"$f":"IF(E11=\"\",\"\",ROUND(D11/C11,4))","v":{"v":1.4925,"d":"1.49"}},{"$f":"IF(D13=\"\",\"\",VLOOKUP(D13,R1:S16,2))","v":"D"},{"$nulls":12},3.2501,"A+"]
[{"$nulls":17},3.5,"A+"]
[{"$nulls":17},3.501,"A++"]
[{"$nulls":17},4,"A++"]

{"sheet":"Result KeyFactorwise NAAC","index":1,"n_rows":23,"n_cols":19,"rows_kept":23,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[4,0,8,0],[9,0,10,0],[11,0,12,0],[13,0,14,0],[15,0,16,0],[17,0,20,0]]}
[{"$f":"+Result!B1","v":"SHRI SHIV CHARAN MATHUR, GOVERNMENT COLLEGE, MANDALGARH"},{"$nulls":16},0,"D"]
["Assessment Matrix for Annual Auditing Programe",{"$nulls":16},1.5,"D"]
[{"$f":"+Result!B3","v":"Session : 2019-20"},{"$nulls":16},1.5001,"C"]
["Crteria","Key Factors Criteria","Weights","Criteria-wise Grade Points","Criteria-wise Grade Points Averages","Crietria-wise Grade","Delete Input Values Key Factor ",{"$nulls":10},2,"C"]
["A. Teaching  and  Learning","A-1 Student Strength",{"$f":"SUM(Input!I7:I8)","v":{"v":5.5,"d":"5.50"}},{"$f":"Input!BG8","v":{"v":0,"d":"0.00"}},{"$f":"IF(C5=\"\",\"\",ROUND(D5/C5,3))","v":{"v":0,"d":"0.0000"}},{"$f":"IF(E5=0,\"D\",VLOOKUP(E5,$R$1:$S$16,2))","v":"D"},{"$nulls":11},2.001,"B"]
[null,"A-2 Inclusivity",{"$f":"SUM(Input!I9:I19)","v":{"v":9,"d":"9.00"}},{"$f":"Input!BG19","v":{"v":25.5,"d":"25.50"}},{"$f":"IF(C6=\"\",\"\",ROUND(D6/C6,3))","v":{"v":2.833,"d":"2.8330"}},"B++",{"$nulls":11},2.5,"B"]
[null,"A-3 Choices",{"$f":"SUM(Input!I20:I25)","v":{"v":5.5,"d":"5.50"}},{"$f":"Input!BG25","v":{"v":10.5,"d":"10.50"}},{"$f":"IF(C7=\"\",\"\",ROUND(D7/C7,3))","v":{"v":1.909,"d":"1.9090"}},"C",{"$nulls":11},2.5001,"B+"]
[null,"A-4 Faculty-Portrayal",{"$f":"SUM(Input!I26:I34)","v":{"v":9,"d":"9.00"}},{"$f":"Input!BG34","v":{"v":13.5,"d":"13.50"}},{"$f":"IF(C8=\"\",\"\",ROUND(D8/C8,3))","v":{"v":1.5,"d":"1.5000"}},"D",{"$nulls":11},2.75,"B+"]
[null,"A-5 Student performance and learning outcomes",{"$f":"SUM(Input!I35:I37)","v":{"v":6,"d":"6.00"}},{"$f":"Input!BG37","v":{"v":0,"d":"0.00"}},{"$f":"IF(C9=\"\",\"\",ROUND(D9/C9,3))","v":{"v":0,"d":"0.0000"}},"D",{"$nulls":11},2.7501,"B++"]
["B. Research and Professional Practices","B-1 Research Output",{"$f":"SUM(Input!I38:I47)","v":{"v":12,"d":"12.00"}},{"$f":"Input!BG47","v":{"v":0,"d":"0.00"}},{"$f":"IF(C10=\"\",\"\",ROUND(D10/C10,3))","v":{"v":0,"d":"0.0000"}},"D",{"$nulls":11},3,"B++"]
[null,"B-2 Academic Enrichment",{"$f":"SUM(Input!I48:I50)","v":{"v":3,"d":"3.00"}},{"$f":"Input!BG50","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.0000"},"D",{"$nulls":11},3.001,"A"]
["C. Infrastructure and Learning Resources","C-1 Physical Assets",{"$f":"SUM(Input!I51:I71)","v":{"v":12.5,"d":"12.50"}},{"$f":"Input!BG71","v":{"v":39.5,"d":"39.50"}},{"v":3.16,"d":"3.1600"},"A","C",{"$nulls":10},3.25,"A"]
[null,"C-2 Office Setup",{"$f":"SUM(Input!I72:I74)","v":{"v":2.5,"d":"2.50"}},{"$f":"Input!BG74","v":{"v":4,"d":"4.00"}},{"v":1.6,"d":"1.6000"},"C",{"$nulls":11},3.2501,"A+"]
["D. Student Support and participation","D-1 Learning Support",{"$f":"SUM(Input!I75:I84)","v":{"v":3.5,"d":"3.50"}},{"$f":"Input!BG84","v":{"v":4,"d":"4.00"}},{"v":1.143,"d":"1.1430"},"D","D",{"$nulls":10},3.5,"A+"]
[null,"D-2 Counseling and Mentoring",{"$f":"SUM(Input!I85:I107)","v":{"v":6.5,"d":"6.50"}},{"$f":"Input!BG107","v":13.25},{"v":2.038,"d":"2.0380"},"B",{"$nulls":11},3.501,"A++"]
["E. Financial Resources and Utilisation","E-1 Financial Management",{"$f":"SUM(Input!I108:I111)","v":{"v":8,"d":"8.00"}},{"$f":"Input!BG111","v":{"v":10,"d":"10.00"}},{"v":1.25,"d":"1.2500"},"D",{"$nulls":11},4,"A++"]
[null,"E-2 Self Financing Efforts",{"$f":"SUM(Input!I112)","v":{"v":2,"d":"2.00"}},{"$f":"Input!BG112","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.0000"},"D"]
["F. Commitment, Leadership and Management","F-1 Societal Footprint",{"$f":"SUM(Input!I113:I115)","v":{"v":1.5,"d":"1.50"}},{"$f":"Input!BG115","v":{"v":1,"d":"1.00"}},{"v":0.667,"d":"0.6670"},"D"]
[null,"F-2 Innovatin, Values and Best practices",{"$f":"SUM(Input!I116:I123)","v":{"v":4.5,"d":"4.50"}},{"$f":"Input!BG123","v":{"v":9,"d":"9.00"}},{"v":2,"d":"2.0000"},"C"]
[null,"F-3 Effective Implementatin of Govt. Schemes",{"$f":"SUM(Input!I124:I131)","v":{"v":6,"d":"6.00"}},{"$f":"Input!BG131","v":{"v":15,"d":"15.00"}},{"v":2.5,"d":"2.5000"},"B"]
[null,"F-4 Strengthening the bond",{"$f":"SUM(Input!I132:I137)","v":{"v":3,"d":"3.00"}},{"$f":"Input!BG137","v":{"v":4,"d":"4.00"}},{"v":1.333,"d":"1.3330"},"D"]
[null,"TOTAL",{"$f":"IF(SUM(C5:C21)=0,\"\",SUM(C5:C21))","v":{"v":100,"d":"100.00"}},{"$f":"IF(SUM(D5:D21)=0,\"\",SUM(D5:D21))","v":149.25}]
[null,"Average",{"$f":"IF(C22=\"\",\"\",ROUND(C22/4,2))","v":{"v":25,"d":"25.00"}},{"$f":"IF(D22=\"\",\"\",ROUND(D22/4,4))","v":{"v":37.3125,"d":"37.31"}}]

{"sheet":"Input","index":2,"n_rows":137,"n_cols":59,"rows_kept":137,"merged":[[0,0,0,9],[0,26,0,28],[1,0,1,9],[1,26,1,28],[2,0,2,9],[2,26,3,28],[3,0,3,9],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,4,23],[4,26,5,26],[4,28,5,47],[4,48,5,48],[5,15,5,16],[5,17,5,18],[5,19,5,20],[5,21,5,22],[5,23,5,24],[6,0,16,0],[6,1,7,1],[6,28,6,47],[7,28,7,47],[8,1,16,1],[8,2,9,2],[8,8,9,8],[8,28,8,47],[9,4,9,5],[9,28,9,47],[10,28,10,47],[11,28,11,47],[12,28,12,47],[13,28,13,47],[14,28,14,47],[15,28,15,47],[16,28,16,47],[17,0,26,0],[17,1,18,1],[17,28,17,47],[18,28,18,47],[19,1,24,1],[19,4,19,5],[19,28,19,47],[20,4,20,5],[20,28,20,47],[21,4,21,5],[21,28,21,47],[22,4,22,5],[22,28,22,47],[23,28,23,47],[24,28,24,47],[25,1,26,1],[25,28,25,47],[26,28,26,47],[27,0,36,0],[27,1,33,1],[27,28,27,47],[28,28,28,47],[29,28,29,47],[30,28,30,47],[31,28,31,47],[32,28,32,47],[33,28,33,47],[34,1,36,1],[34,28,34,47],[35,28,35,47],[36,28,36,47],[37,0,44,0],[37,1,44,1],[37,28,37,47],[38,28,38,47],[39,28,39,47],[40,28,40,47],[41,28,41,47],[42,28,42,47],[43,4,43,5],[43,28,43,47],[44,4,44,5],[44,28,44,47],[45,0,49,0],[45,1,46,1],[45,28,45,47],[46,4,46,5],[46,28,46,47],[47,1,49,1],[47,28,47,47],[48,28,48,47],[49,4,49,5],[49,28,49,47],[50,0,53,0],[50,1,53,1],[50,4,50,5],[50,28,50,47],[51,28,51,47],[52,28,52,47],[53,28,53,47],[54,0,64,0],[54,1,64,1],[54,28,54,47],[55,28,55,47],[56,28,56,47],[57,4,57,5],[57,28,57,47],[58,4,58,5],[58,28,58,47],[59,28,59,47],[60,28,60,47],[61,4,61,5],[61,28,61,47],[62,4,62,5],[62,28,62,47],[63,4,63,5],[63,28,63,47],[64,4,64,5],[64,28,64,47],[65,0,73,0],[65,1,70,1],[65,4,65,5],[65,28,65,47],[66,4,66,5],[66,28,66,47],[67,4,67,5],[67,28,67,47],[68,4,68,5],[68,28,68,47],[69,28,69,47],[70,4,70,5],[70,28,70,47],[71,1,73,1],[71,28,71,47],[72,28,72,47],[73,4,73,5],[73,28,73,47],[74,0,83,0],[74,1,83,1],[74,4,74,5],[74,28,74,47],[75,4,75,5],[75,28,75,47],[76,4,76,5],[76,28,76,47],[77,28,77,47],[78,28,78,47],[79,4,79,5],[79,28,79,47],[80,28,80,47],[81,4,81,5],[81,28,81,47],[82,4,82,5],[82,28,82,47],[83,28,83,47],[84,0,93,0],[84,1,93,1],[84,28,84,47],[85,4,85,5],[85,28,85,47],[86,4,86,5],[86,28,86,47],[87,4,87,5],[87,28,87,47],[88,4,88,5],[88,28,88,47],[89,4,89,5],[89,28,89,47],[90,4,90,5],[90,28,90,47],[91,4,91,5],[91,28,91,47],[92,4,92,5],[92,28,92,47],[93,4,93,5],[93,28,93,47],[94,0,104,0],[94,1,104,1],[94,4,94,5],[94,28,94,47],[95,4,95,5],[95,28,95,47],[96,28,96,47],[97,4,97,5],[97,28,97,47],[98,4,98,5],[98,28,98,47],[99,4,99,5],[99,28,99,47],[100,4,100,5],[100,28,100,47],[101,4,101,5],[101,28,101,47],[102,4,102,5],[102,28,102,47],[103,4,103,5],[103,28,103,47],[104,4,104,5],[104,28,104,47],[105,0,106,0],[105,1,106,1],[105,4,105,5],[105,28,105,47],[106,4,106,5],[106,28,106,47],[107,0,111,0],[107,1,110,1],[107,28,107,47],[108,28,108,47],[109,28,109,47],[110,4,110,5],[110,28,110,47],[111,4,111,5],[111,28,111,47],[112,0,114,0],[112,1,114,1],[112,4,112,5],[112,28,112,47],[113,4,113,5],[113,28,113,47],[114,4,114,5],[114,28,114,47],[115,0,125,0],[115,1,122,1],[115,4,115,5],[115,28,115,47],[116,4,116,5],[116,28,116,47],[117,4,117,5],[117,28,117,47],[118,4,118,5],[118,28,118,47],[119,4,119,5],[119,28,119,47],[120,28,120,47],[121,4,121,5],[121,28,121,47],[122,4,122,5],[122,28,122,47],[123,1,125,1],[123,4,123,5],[123,28,123,47],[124,28,124,47],[125,28,125,47],[126,0,136,0],[126,1,130,1],[126,28,126,47],[127,28,127,47],[128,28,128,47],[129,4,129,5],[129,28,129,47],[130,28,130,47],[131,1,136,1],[131,4,131,5],[131,28,131,47],[132,4,132,5],[132,28,132,47],[133,4,133,5],[133,28,133,47],[134,4,134,5],[134,28,134,47],[135,4,135,5],[135,28,135,47],[136,4,136,5],[136,28,136,47],[137,28,137,44]]}
[{"$f":"+'Result NAAC'!B1","v":"SHRI SHIV CHARAN MATHUR, GOVERNMENT COLLEGE, MANDALGARH"},{"$nulls":25},"PRADEEP MODI"]
[{"$f":"+'Result NAAC'!B2","v":"Assessment Matrix for Annual Auditing Programe"},{"$nulls":25},9413307717]
[{"$f":"+'Result NAAC'!B3","v":"Session : 2019-20"},{"$nulls":25},"pradeepjimodi@gmail.com"]
["Detailed Report"]
["Crtieria","Key Indicators","S. No.","Parameters","Input Values",null,"Percentage or Ratio points","Credits","Weightage","Weighted Credits",0,1,2,3,4,"Credits",{"$nulls":10},"Documental Proof Available ?",null,"Space for Notes for Future Reference",{"$nulls":19},"Error Message"]
[{"$nulls":15},0,null,1,null,2,null,3,null,4,{"$nulls":29},{"$f":"SUM(BB7:BB137)","v":524},100,400,149.25,400,149.25]
["A. Teaching and Learning","A-1 Student Strength",1,"Actual Student Strength as percentage of Sanctioned Strength",84.66,null,{"$f":"IF(E7=\"\",\"\",ROUND(E7/F7,4))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E7=\"\",F7=\"\",F7=0),\"\",SUM(K7:O7))","v":""},{"v":3,"d":"3.00"},{"$f":"IF(H7=\"\",\"\",+H7*I7*Z7)","v":""},{"$f":"IF($G7<$R7%,$K$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G7<$T7%,$G7>$Q7%),$L$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G7<$V7%,$G7>$S7%),$M$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G7<$X7%,$G7>$U7%),$N$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G7<Y7%,G7>W7%),$O$5,\"\")","v":{"$error":"#DIV/0!"}},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,{"$f":"IF(AA7=\"YES\",1,0)*IF(AW7=\"ERROR INPUT\",0,1)","v":0},"YES",{"$nulls":21},{"$f":"IF(E7>F7,\"ERROR INPUT\",\"\")","v":"ERROR INPUT"},{"$nulls":4},4,{"$f":"+I7","v":{"v":3,"d":"3.00"}},{"$f":"+BB7*BC7","v":12},{"$f":"IF(J7=\"\",0,+J7)","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"1+C7","v":2},"No. of Applications received as the ratio of Sanctioned seats in UG Part-I and PG (Prev. )",1.56,null,{"$f":"IF(E8=\"\",\"\",ROUND(E8/F8,4))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E8=\"\",F8=\"\",F8=0),\"\",SUM(K8:O8))","v":""},{"v":2.5,"d":"2.50"},{"$f":"IF(H8=\"\",\"\",+H8*I8*Z8)","v":""},{"$f":"IF($G8<$R8,$K$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G8<$T8,$G8>$Q8),$L$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G8<$V8,$G8>$S8),$M$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G8<$X8,$G8>$U8),$N$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G8<Y8,G8>W8),$O$5,\"\")","v":{"$error":"#DIV/0!"}},0,0.1999,0.2,0.9999,1,1.4999,1.5,1.9999,2,10000,{"$f":"IF(AA8=\"YES\",1,0)*IF(AW8=\"ERROR INPUT\",0,1)","v":1},"YES",{"$nulls":26},4,{"$f":"+I8","v":{"v":2.5,"d":"2.50"}},{"$f":"+BB8*BC8","v":10},{"$f":"IF(J8=\"\",0,+J8)","v":{"v":0,"d":"0.00"}},{"$f":"+BD8+BD7","v":22},{"$f":"+BE8+BE7","v":0}]
[null,"A-2 Inclusivity",{"$f":"1+C8","v":3},"Percentage of Girls in case of (a) Co Ed. College",53.78,{"$f":"+$E$7","v":84.66},{"$f":"IF(E9=\"\",\"\",ROUND(E9/F9,4))","v":0.6352},{"$f":"IF(OR(E9=\"\",F9=\"\",F9=0),\"\",IF(E10=\"yes\",0,SUM(K9:O9)))","v":4},{"v":1.5,"d":"1.50"},{"$f":"IF(H9=\"\",\"\",+H9*I9*Z9)","v":{"v":6,"d":"6.00"}},{"$f":"IF($G9<$R9%,$K$5,\"\")","v":""},{"$f":"IF(AND($G9<$T9%,$G9>$Q9%),$L$5,\"\")","v":""},{"$f":"IF(AND($G9<$V9%,$G9>$S9%),$M$5,\"\")","v":""},{"$f":"IF(AND($G9<$X9%,$G9>$U9%),$N$5,\"\")","v":""},{"$f":"IF(AND($G9<Y9%,G9>W9%),$O$5,\"\")","v":4},0,9.999,10,"1900-01-19T23:58:33.600",20,29.999,30,49.999,50,10000,1,"YES",{"$nulls":21},{"$f":"IF(E9>F9,\"ERROR INPUT\",\"\")","v":""},{"$nulls":4},4,{"v":1.5,"d":"1.50"},6,{"v":6,"d":"6.00"}]
[{"$nulls":3},"Percentage of Girls in case of  (b) Girls College","NO",null,{"$f":"+E10","v":"NO"},{"$f":"IF(H7=\"\",\"\",IF(G10=\"\",0,SUM(K10:O10)))","v":""},null,{"$f":"IF(H10=\"\",\"\",+H10*I9*Z10)","v":""},{"$f":"IF(OR(E10=\"\",E10=\"NO\"),$K$5,\"\")","v":0},"","","",{"$f":"IF(E10=\"YES\",$O$5,\"\")","v":""},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0,"d":"0.00"},0,{"v":0,"d":"0.00"}]
[null,null,{"$f":"1+C9","v":4},"Percentage of SC",23.62,{"$f":"+$E$7","v":84.66},{"$f":"IF(E11=\"\",\"\",ROUND(E11/F11,4))","v":{"v":0.279,"d":"27.9000%"}},{"$f":"IF(OR(E11=\"\",F11=\"\",F11=0),\"\",SUM(K11:O11))","v":3},{"v":1,"d":"1.00"},{"$f":"IF(H11=\"\",\"\",+H11*I11*Z11)","v":{"v":3,"d":"3.00"}},{"$f":"IF($G11<$R11%,$K$5,\"\")","v":""},"","",3,{"$f":"IF(AND($G11<Y11%,G11>W11%),$O$5,\"\")","v":""},0,0,0.0009,9.9999,10,19.999,20,29.999,30,10000,1,"YES",{"$nulls":21},{"$f":"IF(E11>F11,\"ERROR INPUT\",\"\")","v":""},{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":3,"d":"3.00"}]
[null,null,5,"Percentage of ST",8.97,84.66,{"v":0.106,"d":"10.6000%"},2,{"v":1,"d":"1.00"},{"v":2,"d":"2.00"},"","",2,"","",0,0,0.0009,9.9999,10,19.999,20,29.999,30,10000,1,{"$f":"IF(+$AA$11<>\"\",+$AA$11,\"\")","v":"YES"},{"$nulls":21},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":2,"d":"2.00"}]
[null,null,6,"Percentage of OBC",44.25,84.66,{"v":0.5227,"d":"52.2700%"},4,{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},"","","","",4,0,0,0.0009,14.999,15,29.999,30,44.999,45,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":4,"d":"4.00"}]
[null,null,7,"Percentage of MBC",6.3,84.66,{"v":0.0744,"d":"7.4400%"},4,{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},"","","","",4,0,0,0.0009,1.999,2,3.999,4,5.999,6,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":4,"d":"4.00"}]
[null,null,8,"Percentage of EWS",0.63,84.66,{"v":0.0074,"d":"0.7400%"},1,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},"",1,"","","",0,0,0.0009,1.999,2,3.999,4,5.999,6,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":1,"d":"1.00"}]
[null,null,9,"Percentage of Minorities",2.5,84.66,{"v":0.0295,"d":"2.9500%"},3,{"v":1,"d":"1.00"},{"v":3,"d":"3.00"},"","","",3,"",0,0,0.0009,0.999,1,1.999,2,2.999,3,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":3,"d":"3.00"}]
[null,null,10,"Percentage of Students from other districts",3,84.66,{"v":0.0354,"d":"3.5400%"},2,{"v":0.5,"d":"0.50"},{"v":1,"d":"1.00"},"","",2,"","",0,0,0.0009,1.999,2,3.999,4,5.999,6,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":1,"d":"1.00"}]
["A. Teaching and Learning","A-2 Inclusivity",11,"Percentage of BPL Students",18,84.66,{"v":0.2126,"d":"21.2600%"},3,{"v":0.5,"d":"0.50"},{"v":1.5,"d":"1.50"},"","","",3,"",0,0,0.0009,9.9999,10,19.999,20,29.999,30,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":1.5,"d":"1.50"}]
[null,null,12,"Percentage of students with Special abilities",2E-3,84.66,{"v":0,"d":"0.0000%"},0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},0,"","","","",0,0,0.0009,0.099,0.1,0.1999,0.2,0.2999,0.3,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"},{"$f":"SUM(BD9:BD19)","v":{"v":36,"d":"36.00"}},{"$f":"SUM(BE9:BE19)","v":{"v":25.5,"d":"25.50"}}]
[null,"A-3 Choices",13,"No. of Faculties (Arts, Science, Commerce etc.)",2,null,{"$f":"+E20","v":2},{"$f":"IF(E20=\"\",\"\",SUM(K20:O20))","v":2},{"v":1,"d":"1.00"},{"v":2,"d":"2.00"},{"$f":"IF($E20<$R20,$K$5,\"\")","v":""},{"$f":"IF(AND($E20<$T20,$E20>$Q20),$L$5,\"\")","v":""},{"$f":"IF(AND($E20<$V20,$E20>$S20),$M$5,\"\")","v":2},{"$f":"IF(AND($E20<$X20,$E20>$U20),$N$5,\"\")","v":""},{"$f":"IF(AND($E20<Y20,E20>W20),$O$5,\"\")","v":""},0,0.999,1,1.999,2,2.999,3,3.999,4,10000,1,"YES",{"$nulls":26},4,{"v":1,"d":"1.00"},4,{"v":2,"d":"2.00"}]
[null,null,14,"No. of Subjects offered at UG Courses",7,null,{"$f":"+E21","v":7},{"$f":"IF(E21=\"\",\"\",SUM(K21:O21))","v":2},{"v":1.5,"d":"1.50"},{"v":3,"d":"3.00"},{"$f":"IF($E21<$R21,$K$5,\"\")","v":""},{"$f":"IF(AND($E21<$T21,$E21>$Q21),$L$5,\"\")","v":""},{"$f":"IF(AND($E21<$V21,$E21>$S21),$M$5,\"\")","v":2},{"$f":"IF(AND($E21<$X21,$E21>$U21),$N$5,\"\")","v":""},{"$f":"IF(AND($E21<Y21,E21>W21),$O$5,\"\")","v":""},0,2.999,3,5.999,6,8.999,9,12.999,13,10000,1,{"$f":"IF(+$AA$20<>\"\",+$AA$20,\"\")","v":"YES"},{"$nulls":26},4,{"v":1.5,"d":"1.50"},6,{"v":3,"d":"3.00"}]
[null,null,15,"No. of PG Courses offered",3,null,{"$f":"+E22","v":3},1,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},{"$f":"IF($E22<$R22,$K$5,\"\")","v":""},{"$f":"IF(AND($E22<$T22,$E22>$Q22),$L$5,\"\")","v":1},{"$f":"IF(AND($E22<$V22,$E22>$S22),$M$5,\"\")","v":""},{"$f":"IF(AND($E22<$X22,$E22>$U22),$N$5,\"\")","v":""},{"$f":"IF(AND($E22<Y22,E22>W22),$O$5,\"\")","v":""},0,0.999,1,3.999,4,6.999,7,9.999,10,10000,1,{"$f":"IF(+$AA$20<>\"\",+$AA$20,\"\")","v":"YES"},{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":0.5,"d":"0.50"}]
[null,null,16,"No. of Vocational / skill Courses offered",2,null,{"$f":"+E23","v":2},1,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},{"$f":"IF($E23<$R23,$K$5,\"\")","v":""},{"$f":"IF(AND($E23<$T23,$E23>$Q23),$L$5,\"\")","v":1},{"$f":"IF(AND($E23<$V23,$E23>$S23),$M$5,\"\")","v":""},{"$f":"IF(AND($E23<$X23,$E23>$U23),$N$5,\"\")","v":""},{"$f":"IF(AND($E23<Y23,E23>W23),$O$5,\"\")","v":""},0,0.999,1,5.999,6,10.999,11,15.999,16,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":0.5,"d":"0.50"}]
[null,null,17,"Percentage of students enrolled in vocational courses",0,{"$f":"+$E$7","v":84.66},{"$f":"IF(E24=\"\",\"\",ROUND(E24/F24,4))","v":{"v":0,"d":"0.0000%"}},{"$f":"IF(OR(E24=\"\",F24=\"\",F24=0),\"\",SUM(K24:O24))","v":0},{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"$f":"IF($G24<$R24%,$K$5,\"\")","v":0},{"$f":"IF(AND($G24<$T24%,$G24>$Q24%),$L$5,\"\")","v":""},{"$f":"IF(AND($G24<$V24%,$G24>$S24%),$M$5,\"\")","v":""},{"$f":"IF(AND($G24<$X24%,$G24>$U24%),$N$5,\"\")","v":""},{"$f":"IF(AND($G24<Y24%,G24>W24%),$O$5,\"\")","v":""},0,0.999,1,2.999,3,5.999,6,9.999,10,10000,1,"YES",{"$nulls":21},{"$f":"IF(E24>F24,\"ERROR INPUT\",\"\")","v":""},{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,18,"Percentage of Students enrolled in Skill Development Courses (RSLDC and Other agencies)",5.5,84.66,{"v":0.065,"d":"6.5000%"},3,{"v":1.5,"d":"1.50"},{"v":4.5,"d":"4.50"},"","","",3,"",0,0.999,1,2.999,3,5.999,6,9.999,10,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":1.5,"d":"1.50"},6,{"v":4.5,"d":"4.50"},{"$f":"SUM(BD20:BD25)","v":22},{"$f":"SUM(BE20:BE25)","v":10.5}]
[null,"A-4 Faculty-Portrayal",19,"Working faculty (including work arrangement, guest faculty, adhoc) as percentage of sanctioned posts",5,20,{"v":0.25,"d":"25.0000%"},1,{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},{"$f":"IF($G26<$R26%,$K$5,\"\")","v":""},{"$f":"IF(AND($G26<$T26%,$G26>$Q26%),$L$5,\"\")","v":1},{"$f":"IF(AND($G26<$V26%,$G26>$S26%),$M$5,\"\")","v":""},{"$f":"IF(AND($G26<$X26%,$G26>$U26%),$N$5,\"\")","v":""},{"$f":"IF(AND($G26<Y26%,G26>W26%),$O$5,\"\")","v":""},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":1.5,"d":"1.50"},6,{"v":1.5,"d":"1.50"}]
[null,null,20,"Percentage of filled posts (regular appointments) against sanctioned posts",25,{"$f":"+F26","v":20},{"v":1.25,"d":"125.0000%"},4,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"IF($G27<$R27%,$K$5,\"\")","v":""},{"$f":"IF(AND($G27<$T27%,$G27>$Q27%),$L$5,\"\")","v":""},{"$f":"IF(AND($G27<$V27%,$G27>$S27%),$M$5,\"\")","v":""},{"$f":"IF(AND($G27<$X27%,$G27>$U27%),$N$5,\"\")","v":""},{"$f":"IF(AND($G27<Y27%,G27>W27%),$O$5,\"\")","v":4},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,0,"YES",{"$nulls":21},"ERROR INPUT",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"}]
["A. Teaching and Learning","A-4 Faculty-Portrayal",21,"Percentage of working faculty members having Ph.D Degree",0,{"$f":"+$E$27","v":25},{"v":0,"d":"0.0000%"},0,{"v":1.5,"d":"1.50"},{"v":0,"d":"0.00"},{"$f":"IF($G28<$R28%,$K$5,\"\")","v":0},{"$f":"IF(AND($G28<$T28%,$G28>$Q28%),$L$5,\"\")","v":""},{"$f":"IF(AND($G28<$V28%,$G28>$S28%),$M$5,\"\")","v":""},{"$f":"IF(AND($G28<$X28%,$G28>$U28%),$N$5,\"\")","v":""},{"$f":"IF(AND($G28<Y28%,G28>W28%),$O$5,\"\")","v":""},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":1.5,"d":"1.50"},6,{"v":0,"d":"0.00"}]
[null,null,22,"Percentage of working faculty members having M.Phil. Degree (other than Ph.D)",0,{"$f":"+$E$27","v":25},{"$f":"IF(E29=\"\",\"\",ROUND(E29/F29,4))","v":{"v":0,"d":"0.0000%"}},0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"$f":"IF($G29<$R29%,$K$5,\"\")","v":0},{"$f":"IF(AND($G29<$T29%,$G29>$Q29%),$L$5,\"\")","v":""},{"$f":"IF(AND($G29<$V29%,$G29>$S29%),$M$5,\"\")","v":""},{"$f":"IF(AND($G29<$X29%,$G29>$U29%),$N$5,\"\")","v":""},{"$f":"IF(AND($G29<Y29%,G29>W29%),$O$5,\"\")","v":""},0,1.999,2,3.999,4,5.999,6,7.999,8,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,23,"Percentage of working faculty members awarded PDF/D.Litt",0,{"$f":"+$E$27","v":25},{"v":0,"d":"0.0000%"},0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"$f":"IF($G30<$R30%,$K$5,\"\")","v":0},{"$f":"IF(AND($G30<$T30%,$G30>$Q30%),$L$5,\"\")","v":""},{"$f":"IF(AND($G30<$V30%,$G30>$S30%),$M$5,\"\")","v":""},{"$f":"IF(AND($G30<$X30%,$G30>$U30%),$N$5,\"\")","v":""},{"$f":"IF(AND($G30<Y30%,G30>W30%),$O$5,\"\")","v":""},0,1.999,2,3.999,4,5.999,6,7.999,8,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,24,"Student-Teacher ratio as per sanctioned posts",{"$f":"+$E$7","v":84.66},{"$f":"+F27","v":20},{"$f":"IF(E31=\"\",\"\",ROUND(E31/F31,4))","v":{"v":4.233,"d":"4.2330"}},4,{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"$f":"IF($G31>$R31,$K$5,\"\")","v":""},{"$f":"IF(AND($G31>$T31,$G31<$Q31),$L$5,\"\")","v":""},{"$f":"IF(AND($G31>$V31,$G31<$S31),$M$5,\"\")","v":""},{"$f":"IF(AND($G31>$X31,$G31<$U31),$N$5,\"\")","v":""},{"$f":"IF(AND($G31>Y31,G31<W31),$O$5,\"\")","v":4},1000,100.0001,100,80.0001,80,60.0001,60,40.0001,40,1E-4,1,"YES",{"$nulls":26},4,{"v":1,"d":"1.00"},4,{"v":4,"d":"4.00"}]
[null,null,25,"Student-Teacher ratio as per working teachers",{"$f":"+$E$7","v":84.66},{"$f":"+$E$26","v":5},{"$f":"IF(E32=\"\",\"\",ROUND(E32/F32,4))","v":{"v":16.932,"d":"16.9320"}},4,{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"$f":"IF($G32>$R32,$K$5,\"\")","v":""},{"$f":"IF(AND($G32>$T32,$G32<$Q32),$L$5,\"\")","v":""},{"$f":"IF(AND($G32>$V32,$G32<$S32),$M$5,\"\")","v":""},{"$f":"IF(AND($G32>$X32,$G32<$U32),$N$5,\"\")","v":""},{"$f":"IF(AND($G32>Y32,G32<W32),$O$5,\"\")","v":4},1000,100.0001,100,80.0001,80,60.0001,60,40.0001,40,1E-4,1,"YES",{"$nulls":26},4,{"v":1,"d":"1.00"},4,{"v":4,"d":"4.00"}]
[null,null,26,"Target of content-wise teaching achieved in percentage",80,80,{"$f":"IF(E33=\"\",\"\",ROUND(E33/F33,4))","v":{"v":1,"d":"100.0000%"}},4,{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"$f":"IF($G33<$R33%,$K$5,\"\")","v":""},{"$f":"IF(AND($G33<$T33%,$G33>$Q33%),$L$5,\"\")","v":""},{"$f":"IF(AND($G33<$V33%,$G33>$S33%),$M$5,\"\")","v":""},{"$f":"IF(AND($G33<$X33%,$G33>$U33%),$N$5,\"\")","v":""},{"$f":"IF(AND($G33<Y33%,G33>W33%),$O$5,\"\")","v":4},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,1,"YES",{"$nulls":26},4,{"v":1,"d":"1.00"},4,{"v":4,"d":"4.00"}]
[null,null,27,"Percentage of faculty members contributed to devlopment of E-content (which is being utilised in more than one institute)",0,{"$f":"+$E$27","v":25},{"$f":"IF(E34=\"\",\"\",ROUND(E34/F34,4))","v":{"v":0,"d":"0.0000%"}},0,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},0,"","","","",0,19.999,20,39.999,40,59.999,60,79.999,80,10000,0,"NO",{"$nulls":21},{"$f":"IF(E34>F34,\"ERROR INPUT\",\"\")","v":""},{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"},{"$f":"SUM(BD26:BD34)","v":{"v":36,"d":"36.00"}},{"$f":"SUM(BE26:BE34)","v":{"v":13.5,"d":"13.50"}}]
[null,"A-5 Student performance and learning outcomes",28,"Pass percentage in last University result",91.06,null,{"$error":"#DIV/0!"},"",{"v":3,"d":"3.00"},"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,0,"YES",{"$nulls":21},{"$f":"IF(E35>F35,\"ERROR INPUT\",\"\")","v":"ERROR INPUT"},{"$nulls":4},4,{"v":3,"d":"3.00"},12,{"v":0,"d":"0.00"}]
[null,null,29,"Percentage of Students scored 60% and above in University result",1.65,{"$f":"+$F$35","v":0},{"$error":"#DIV/0!"},"",{"v":2,"d":"2.00"},"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,9.999,10,19.999,20,29.999,30,39.999,40,10000,0,{"$f":"IF(+$AA$35<>\"\",+$AA$35,\"\")","v":"YES"},{"$nulls":21},{"$f":"IF(E36>F36,\"ERROR INPUT\",\"\")","v":"ERROR INPUT"},{"$nulls":4},4,{"v":2,"d":"2.00"},8,{"v":0,"d":"0.00"}]
[null,null,30,"Percentage of Students scored 75% and above in University result",0,{"$f":"+$F$35","v":0},{"$error":"#DIV/0!"},"",{"v":1,"d":"1.00"},"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,5e-05,1E-4,4.999,5,9.999,10,14.9999,15,10000,1,{"$f":"IF(+$AA$35<>\"\",+$AA$35,\"\")","v":"YES"},{"$nulls":21},{"$f":"IF(E37>F37,\"ERROR INPUT\",\"\")","v":""},{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"},{"$f":"SUM(BD35:BD37)","v":{"v":24,"d":"24.00"}},{"$f":"SUM(BE35:BE37)","v":{"v":0,"d":"0.00"}}]
["B. Research and Professional Practices","B-1 Research Output",31,"Percentage of faculty members having 5 and more research papers published during last 3 years",40,{"$f":"+$E$27","v":25},{"$f":"IF(E38=\"\",\"\",ROUND(E38/F38,4))","v":{"v":1.6,"d":"160.0000%"}},4,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},"","","","",4,0,5e-05,1E-4,1.9999,2,2.9999,3,3.9999,4,10000,0,{"$nulls":22},{"$f":"IF(E38>F38,\"ERROR INPUT\",\"\")","v":"ERROR INPUT"},{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"}]
[null,null,32,"Percentage of faculty members authored/co-authored at least one book",0,25,{"$f":"IF(E39=\"\",\"\",ROUND(E39/F39,4))","v":{"v":0,"d":"0.0000%"}},0,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},0,"","","","",0,5e-05,1E-4,1.9999,2,2.9999,3,3.9999,4,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"}]
[null,null,33,"Percentage of faculty members recognized as research supervisor",0,25,{"v":0,"d":"0.0000%"},0,{"v":1.5,"d":"1.50"},{"v":0,"d":"0.00"},0,"","","","",0,5e-05,1E-4,1.9999,2,2.9999,3,3.9999,4,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":1.5,"d":"1.50"},6,{"v":0,"d":"0.00"}]
[null,null,34,"Percentage of faculty members under whom at least one scholar is awarded Ph.D.",0,25,{"v":0,"d":"0.0000%"},0,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},0,"","","","",0,5e-05,1E-4,1.9999,2,2.9999,3,3.9999,4,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"}]
[null,null,35,"Percentage of faculty members presented at least 2 papers in international seminars / conferences during last 3 years",40,25,{"v":1.6,"d":"160.0000%"},4,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},"","","","",4,0,5e-05,1E-4,9.9999,10,19.9999,20,29.9999,30,10000,0,{"$nulls":22},"ERROR INPUT",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"}]
[null,null,36,"Percentage faculty members presented at least 3 papers in national seminars / conferences during last 3 years",40,25,{"$f":"IF(E43=\"\",\"\",ROUND(E43/F43,4))","v":{"v":1.6,"d":"160.0000%"}},4,{"v":1.5,"d":"1.50"},{"v":0,"d":"0.00"},"","","","",4,0,5e-05,1E-4,19.9999,20,29.9999,30,39.9999,40,10000,0,"YES",{"$nulls":21},"ERROR INPUT",{"$nulls":4},4,{"v":1.5,"d":"1.50"},6,{"v":0,"d":"0.00"}]
[null,null,37,"No. of International/National seminars / conferences/workshops organized in last 5 years",0,null,{"$f":"+E44","v":0},{"$f":"IF(E44=\"\",\"\",SUM(K44:O44))","v":0},{"v":1.5,"d":"1.50"},{"v":0,"d":"0.00"},{"$f":"IF($E44<$R44,$K$5,\"\")","v":0},{"$f":"IF(AND($E44<$T44,$E44>$Q44),$L$5,\"\")","v":""},{"$f":"IF(AND($E44<$V44,$E44>$S44),$M$5,\"\")","v":""},{"$f":"IF(AND($E44<$X44,$E44>$U44),$N$5,\"\")","v":""},{"$f":"IF(AND($E44<Y44,E44>W44),$O$5,\"\")","v":""},0,0.999,1,1.999,2,2.999,3,3.999,4,10000,0,{"$nulls":27},4,{"v":1.5,"d":"1.50"},6,{"v":0,"d":"0.00"}]
[null,null,38,"No. of faculty members who have acted as convener / Organizing secretary in national seminar / conferences in last 5 years",0,null,{"$f":"+E45","v":0},0,{"v":1.5,"d":"1.50"},{"v":0,"d":"0.00"},{"$f":"IF($E45<$R45,$K$5,\"\")","v":0},{"$f":"IF(AND($E45<$T45,$E45>$Q45),$L$5,\"\")","v":""},{"$f":"IF(AND($E45<$V45,$E45>$S45),$M$5,\"\")","v":""},{"$f":"IF(AND($E45<$X45,$E45>$U45),$N$5,\"\")","v":""},{"$f":"IF(AND($E45<Y45,E45>W45),$O$5,\"\")","v":""},0,0.999,1,1.999,2,2.999,3,3.999,4,10000,0,{"$nulls":27},4,{"v":1.5,"d":"1.50"},6,{"v":0,"d":"0.00"}]
["B. Research and Professional Practices","B-1 Research Output",39,"Percentage of faculty members who have been awarded Research Projects from  UGC, ICSSR and other research funding agency",0,{"$f":"+$E$27","v":25},{"$f":"IF(E46=\"\",\"\",ROUND(E46/F46,4))","v":{"v":0,"d":"0.0000%"}},{"$f":"IF(OR(E46=\"\",F46=\"\",F46=0),\"\",SUM(K46:O46))","v":0},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"IF($G46<$R46%,$K$5,\"\")","v":0},{"$f":"IF(AND($G46<$T46%,$G46>$Q46%),$L$5,\"\")","v":""},{"$f":"IF(AND($G46<$V46%,$G46>$S46%),$M$5,\"\")","v":""},{"$f":"IF(AND($G46<$X46%,$G46>$U46%),$N$5,\"\")","v":""},{"$f":"IF(AND($G46<Y46%,G46>W46%),$O$5,\"\")","v":""},0,5e-05,1E-4,1.9999,2,4.9999,5,8.9999,9,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"}]
[null,null,40,"No. of faculty members, who are associated with any foreign agency for research / referee assignments",0,null,{"$f":"+E47","v":0},{"$f":"IF(E47=\"\",\"\",SUM(K47:O47))","v":0},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"IF($E47<$R47,$K$5,\"\")","v":0},{"$f":"IF(AND($E47<$T47,$E47>$Q47),$L$5,\"\")","v":""},{"$f":"IF(AND($E47<$V47,$E47>$S47),$M$5,\"\")","v":""},{"$f":"IF(AND($E47<$X47,$E47>$U47),$N$5,\"\")","v":""},{"$f":"IF(AND($E47<Y47,E47>W47),$O$5,\"\")","v":""},0,0.999,1,1.999,2,2.999,3,3.999,4,10000,0,{"$nulls":27},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"},{"$f":"SUM(BD38:BD47)","v":{"v":48,"d":"48.00"}},{"$f":"SUM(BE38:BE47)","v":{"v":0,"d":"0.00"}}]
[null,"B-2 Academic Enrichment",41,"Percentage of faculty members associated with academic associations",0,{"$f":"+$E$27","v":25},{"$f":"IF(E48=\"\",\"\",ROUND(E48/F48,4))","v":{"v":0,"d":"0.0000%"}},{"$f":"IF(OR(E48=\"\",F48=\"\",F48=0),\"\",SUM(K48:O48))","v":0},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"IF($G48<$R48%,$K$5,\"\")","v":0},{"$f":"IF(AND($G48<$T48%,$G48>$Q48%),$L$5,\"\")","v":""},{"$f":"IF(AND($G48<$V48%,$G48>$S48%),$M$5,\"\")","v":""},{"$f":"IF(AND($G48<$X48%,$G48>$U48%),$N$5,\"\")","v":""},{"$f":"IF(AND($G48<Y48%,G48>W48%),$O$5,\"\")","v":""},0,5e-05,1E-4,19.9999,20,29.9999,30,39.9999,40,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"}]
[null,null,42,"Percentage of faculty members who have attended international level academic events / programmes outside India (In last 5 years)",0,25,{"v":0,"d":"0.0000%"},0,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"IF($G49<$R49%,$K$5,\"\")","v":0},{"$f":"IF(AND($G49<$T49%,$G49>$Q49%),$L$5,\"\")","v":""},{"$f":"IF(AND($G49<$V49%,$G49>$S49%),$M$5,\"\")","v":""},{"$f":"IF(AND($G49<$X49%,$G49>$U49%),$N$5,\"\")","v":""},{"$f":"IF(AND($G49<Y49%,G49>W49%),$O$5,\"\")","v":""},0,0,0.0009,0.999,1,1.999,2,2.999,3,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"}]
[null,null,43,"Number of IPRs (Patents, Copyrights, Trade marks etc.) if any, in the name of faculty member of the college",0,null,{"$f":"+E50","v":0},{"$f":"IF(E50=\"\",\"\",SUM(K50:O50))","v":0},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"IF($E50<$R50,$K$5,\"\")","v":0},{"$f":"IF(AND($E50<$T50,$E50>$Q50),$L$5,\"\")","v":""},{"$f":"IF(AND($E50<$V50,$E50>$S50),$M$5,\"\")","v":""},{"$f":"IF(AND($E50<$X50,$E50>$U50),$N$5,\"\")","v":""},{"$f":"IF(AND($E50<Y50,E50>W50),$O$5,\"\")","v":""},0,0.999,1,1.999,2,2.999,3,3.999,4,10000,0,{"$nulls":27},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"},{"$f":"SUM(BD48:BD50)","v":{"v":12,"d":"12.00"}},{"$f":"SUM(BE48:BE50)","v":{"v":0,"d":"0.00"}}]
["C. Infrastructure and Learning Resources","C-1 Physical Assets",44,"Whether the college has its own building","YES",null,{"$f":"+E51","v":"YES"},{"$f":"IF(E51=\"\",\"\",SUM(K51:O51))","v":4},{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF(OR(E51=\"\",E51=\"NO\"),$K$5,\"\")","v":""},{"$f":"IF(AND($G51<$T51%,$G51>$Q51%),$L$5,\"\")","v":""},{"$f":"IF(AND($G51<$V51%,$G51>$S51%),$M$5,\"\")","v":""},{"$f":"IF(AND($G51<$X51%,$G51>$U51%),$N$5,\"\")","v":""},{"$f":"IF(E51=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,45,"Ratio of total students to No. of classrooms in the college",{"$f":"+$E$7","v":84.66},12,{"$f":"IF(E52=\"\",\"\",ROUND(E52/F52,4))","v":{"v":7.055,"d":"7.0550"}},{"$f":"IF(OR(E52=\"\",F52=\"\",F52=0),\"\",SUM(K52:O52))","v":4},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"$f":"IF($G52>$R52,$K$5,\"\")","v":""},{"$f":"IF(AND($G52>$T52,$G52<$Q52),$L$5,\"\")","v":""},{"$f":"IF(AND($G52>$V52,$G52<$S52),$M$5,\"\")","v":""},{"$f":"IF(AND($G52>$X52,$G52<$U52),$N$5,\"\")","v":""},{"$f":"IF(AND($G52>Y52,G52<W52),$O$5,\"\")","v":4},1000,150.0001,150,125.0001,125,100.0001,100,80.0001,80,1E-4,1,"YES",{"$nulls":26},4,{"v":1,"d":"1.00"},4,{"v":4,"d":"4.00"}]
[null,null,46,"Ratio of students in practical subjects to the number of labs",858,1,{"$f":"IF(E53=\"\",\"\",ROUND(E53/F53,4))","v":{"v":858,"d":"858.0000"}},0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"$f":"IF($G53>$R53,$K$5,\"\")","v":0},{"$f":"IF(AND($G53>$T53,$G53<$Q53),$L$5,\"\")","v":""},{"$f":"IF(AND($G53>$V53,$G53<$S53),$M$5,\"\")","v":""},{"$f":"IF(AND($G53>$X53,$G53<$U53),$N$5,\"\")","v":""},{"$f":"IF(AND($G53>Y53,G53<W53),$O$5,\"\")","v":""},1000,150.0001,150,120.0001,120,90.0001,90,60.0001,60,1E-4,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,47,"Ratio of student furniture to the total number of class rooms",580,{"$f":"+$F$52","v":12},{"$f":"IF(E54=\"\",\"\",ROUND(E54/F54,4))","v":48.3333},1,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"IF($G54<$R54,$K$5,\"\")","v":""},{"$f":"IF(AND($G54<$T54,$G54>$Q54),$L$5,\"\")","v":1},{"$f":"IF(AND($G54<$V54,$G54>$S54),$M$5,\"\")","v":""},{"$f":"IF(AND($G54<$X54,$G54>$U54),$N$5,\"\")","v":""},{"$f":"IF(AND($G54<Y54,G54>W54),$O$5,\"\")","v":""},0,19.9999,20,49.9999,50,69.9999,70,89.9999,90,10000,1,"YES",{"$nulls":26},4,{"v":1,"d":"1.00"},4,{"v":1,"d":"1.00"}]
["C. Infrastructure and Learning Resources","C-1 Physical Assets",48,"Percentage of class rooms / labs equipped with working fans and tube lights / bulbs",13,{"$f":"+$F$52+$F$53","v":13},{"$f":"IF(E55=\"\",\"\",ROUND(E55/F55,4))","v":{"v":1,"d":"100.0000%"}},4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF($G55<$R55%,$K$5,\"\")","v":""},{"$f":"IF(AND($G55<$T55%,$G55>$Q55%),$L$5,\"\")","v":""},{"$f":"IF(AND($G55<$V55%,$G55>$S55%),$M$5,\"\")","v":""},{"$f":"IF(AND($G55<$X55%,$G55>$U55%),$N$5,\"\")","v":""},{"$f":"IF(AND($G55<Y55%,G55>W55%),$O$5,\"\")","v":4},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,49,"Ratio of number of boys students to the No. of toilets",{"$f":"IF(E10=\"yes\",\"\",+E7-E9)","v":30.879999999999995},18,{"$f":"IF(E56=\"\",\"\",ROUND(E56/F56,4))","v":1.7156},4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF($G56>$R56,$K$5,\"\")","v":""},{"$f":"IF(AND($G56>$T56,$G56<$Q56),$L$5,\"\")","v":""},{"$f":"IF(AND($G56>$V56,$G56<$S56),$M$5,\"\")","v":""},{"$f":"IF(AND($G56>$X56,$G56<$U56),$N$5,\"\")","v":""},{"$f":"IF(AND($G56>Y56,G56<W56),$O$5,\"\")","v":4},1000,150.0001,150,120.0001,120,90.0001,90,60.0001,60,1E-4,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,50,"Ratio of number of girls students to the No. of toilets",{"$f":"IF(E56=\"\",$E$7,+$E$7-E56)","v":53.78},13,{"$f":"IF(E57=\"\",\"\",ROUND(E57/F57,4))","v":4.1369},4,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"$f":"IF($G57>$R57,$K$5,\"\")","v":""},{"$f":"IF(AND($G57>$T57,$G57<$Q57),$L$5,\"\")","v":""},{"$f":"IF(AND($G57>$V57,$G57<$S57),$M$5,\"\")","v":""},{"$f":"IF(AND($G57>$X57,$G57<$U57),$N$5,\"\")","v":""},{"$f":"IF(AND($G57>Y57,G57<W57),$O$5,\"\")","v":4},1000,150.0001,150,120.0001,120,90.0001,90,60.0001,60,1E-4,0,"YES",{"$nulls":21},"ERROR INPUT",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,51,"Girls common room facility","YES",null,{"$f":"+E58","v":"YES"},{"$f":"IF(E58=\"\",\"\",SUM(K58:O58))","v":4},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"$f":"IF(OR(E58=\"\",E58=\"NO\"),$K$5,\"\")","v":""},{"$f":"IF(AND($G58<$T58%,$G58>$Q58%),$L$5,\"\")","v":""},{"$f":"IF(AND($G58<$V58%,$G58>$S58%),$M$5,\"\")","v":""},{"$f":"IF(AND($G58<$X58%,$G58>$U58%),$N$5,\"\")","v":""},{"$f":"IF(E58=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":1,"d":"1.00"},4,{"v":4,"d":"4.00"}]
[null,null,52,"Availability of Staff room","YES",null,{"$f":"+E59","v":"YES"},{"$f":"IF(E59=\"\",\"\",SUM(K59:O59))","v":4},{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF(OR(E59=\"\",E59=\"NO\"),$K$5,\"\")","v":""},"","","",{"$f":"IF(E59=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,53,"Department rooms in percentage to No. of subjects being taught in the college",2,null,{"$f":"IF(E60=\"\",\"\",ROUND(E60/F60,4))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E60=\"\",F60=\"\",F60=0),\"\",SUM(K60:O60))","v":""},{"v":0.5,"d":"0.50"},"",{"$f":"IF($G60<$R60%,$K$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G60<$T60%,$G60>$Q60%),$L$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G60<$V60%,$G60>$S60%),$M$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G60<$X60%,$G60>$U60%),$N$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G60<Y60%,G60>W60%),$O$5,\"\")","v":{"$error":"#DIV/0!"}},0,5e-05,1E-4,24.9999,25,49.9999,50,74.9999,75,10000,0,"YES",{"$nulls":21},"ERROR INPUT",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,54,"Ratio of number of faculty members to the No. of toilets",{"$f":"+$E$26","v":5},3,{"$f":"IF(E61=\"\",\"\",ROUND(E61/F61,4))","v":1.6667},4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF($G61>$R61,$K$5,\"\")","v":""},{"$f":"IF(AND($G61>$T61,$G61<$Q61),$L$5,\"\")","v":""},{"$f":"IF(AND($G61>$V61,$G61<$S61),$M$5,\"\")","v":""},{"$f":"IF(AND($G61>$X61,$G61<$U61),$N$5,\"\")","v":""},{"$f":"IF(AND($G61>Y61,G61<W61),$O$5,\"\")","v":4},1000,80.0001,80,60.0001,60,40.0001,40,20.0001,20,1E-4,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,55,"No. of computers in ICT labs",20,null,{"$f":"+E62","v":20},{"$f":"IF(E62=\"\",\"\",SUM(K62:O62))","v":3},{"v":0.5,"d":"0.50"},{"v":1.5,"d":"1.50"},{"$f":"IF($E62<$R62,$K$5,\"\")","v":""},{"$f":"IF(AND($E62<$T62,$E62>$Q62),$L$5,\"\")","v":""},{"$f":"IF(AND($E62<$V62,$E62>$S62),$M$5,\"\")","v":""},{"$f":"IF(AND($E62<$X62,$E62>$U62),$N$5,\"\")","v":3},{"$f":"IF(AND($E62<Y62,E62>W62),$O$5,\"\")","v":""},0,0.999,1,5.9999,6,10.9999,11,20.9999,21,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":1.5,"d":"1.50"}]
[null,null,56,"Availability of seminar / conference room in the college","YES",null,"YES",4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF(OR(E63=\"\",E63=\"NO\"),$K$5,\"\")","v":""},{"$f":"IF(AND($G63<$T63%,$G63>$Q63%),$L$5,\"\")","v":""},{"$f":"IF(AND($G63<$V63%,$G63>$S63%),$M$5,\"\")","v":""},{"$f":"IF(AND($G63<$X63%,$G63>$U63%),$N$5,\"\")","v":""},{"$f":"IF(E63=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,57,"Availability of Safe/Clean drinking water with functional RO system","YES",null,"YES",4,{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"$f":"IF(OR(E64=\"\",E64=\"NO\"),$K$5,\"\")","v":""},"","","",{"$f":"IF(E64=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":1,"d":"1.00"},4,{"v":4,"d":"4.00"}]
[null,null,58,"Water harvesting system/ provision in the college","YES",null,"YES",4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF(OR(E65=\"\",E65=\"NO\"),$K$5,\"\")","v":""},"","","",{"$f":"IF(E65=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
["C. Infrastructure and Learning Resources","C-1 Physical Assets",59,"Availibility of Language Lab","YES",null,"YES",4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF(OR(E66=\"\",E66=\"NO\"),$K$5,\"\")","v":""},"","","",{"$f":"IF(E66=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,60,"Whether the campus is Wi-Fi enabled","YES",null,"YES",4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF(OR(E67=\"\",E67=\"NO\"),$K$5,\"\")","v":""},"","","",{"$f":"IF(E67=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,61,"No. of smart classrooms",2,null,2,2,{"v":0.5,"d":"0.50"},{"v":1,"d":"1.00"},{"$f":"IF($E68<$R68,$K$5,\"\")","v":""},{"$f":"IF(AND($E68<$T68,$E68>$Q68),$L$5,\"\")","v":""},{"$f":"IF(AND($E68<$V68,$E68>$S68),$M$5,\"\")","v":2},{"$f":"IF(AND($E68<$X68,$E68>$U68),$N$5,\"\")","v":""},{"$f":"IF(AND($E68<Y68,E68>W68),$O$5,\"\")","v":""},0,0.999,1,1.9999,2,2.9999,3,3.9999,4,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":1,"d":"1.00"}]
[null,null,62,"Ramp and other facilities for physically challenged students","YES",null,"YES",4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF(OR(E69=\"\",E69=\"NO\"),$K$5,\"\")","v":""},{"$f":"IF(AND($G69<$T69%,$G69>$Q69%),$L$5,\"\")","v":""},{"$f":"IF(AND($G69<$V69%,$G69>$S69%),$M$5,\"\")","v":""},{"$f":"IF(AND($G69<$X69%,$G69>$U69%),$N$5,\"\")","v":""},{"$f":"IF(E69=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,63,"Percentage of capacity of power generation through Generator / inverter/Solar panel to total electricity requirement of the college",11,5,{"$f":"IF(E70=\"\",\"\",ROUND(E70/F70,4))","v":{"v":2.2,"d":"220.0000%"}},{"$f":"IF(OR(E70=\"\",F70=\"\",F70=0),\"\",SUM(K70:O70))","v":4},{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF($G70<$R70%,$K$5,\"\")","v":""},{"$f":"IF(AND($G70<$T70%,$G70>$Q70%),$L$5,\"\")","v":""},{"$f":"IF(AND($G70<$V70%,$G70>$S70%),$M$5,\"\")","v":""},{"$f":"IF(AND($G70<$X70%,$G70>$U70%),$N$5,\"\")","v":""},{"$f":"IF(AND($G70<Y70%,G70>W70%),$O$5,\"\")","v":4},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,64,"Availability of Audio / video system in the college (Mic, TV, Projector, Laptops etc.)","YES",null,{"$f":"+E71","v":"YES"},{"$f":"IF(E71=\"\",\"\",SUM(K71:O71))","v":4},{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF(OR(E71=\"\",E71=\"NO\"),$K$5,\"\")","v":""},{"$f":"IF(AND($G71<$T71%,$G71>$Q71%),$L$5,\"\")","v":""},{"$f":"IF(AND($G71<$V71%,$G71>$S71%),$M$5,\"\")","v":""},{"$f":"IF(AND($G71<$X71%,$G71>$U71%),$N$5,\"\")","v":""},{"$f":"IF(E71=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"},{"$f":"SUM(BD51:BD71)","v":{"v":50,"d":"50.00"}},{"$f":"SUM(BE51:BE71)","v":{"v":39.5,"d":"39.50"}}]
[null,"C-2 Office Setup",65,"Percentage of working Ministerial staff to no. of sanctioned posts (including Lab asstts.)",1,4,{"$f":"IF(E72=\"\",\"\",ROUND(E72/F72,4))","v":{"v":0.25,"d":"25.0000%"}},{"$f":"IF(OR(E72=\"\",F72=\"\",F72=0),\"\",SUM(K72:O72))","v":1},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"IF($G72<$R72%,$K$5,\"\")","v":""},{"$f":"IF(AND($G72<$T72%,$G72>$Q72%),$L$5,\"\")","v":1},{"$f":"IF(AND($G72<$V72%,$G72>$S72%),$M$5,\"\")","v":""},{"$f":"IF(AND($G72<$X72%,$G72>$U72%),$N$5,\"\")","v":""},{"$f":"IF(AND($G72<Y72%,G72>W72%),$O$5,\"\")","v":""},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,{"$f":"IF(AA72=\"YES\",1,0)*IF(AW72=\"ERROR INPUT\",0,1)","v":1},"YES",{"$nulls":21},"",{"$nulls":4},4,{"$f":"+I72","v":{"v":1,"d":"1.00"}},{"$f":"+BB72*BC72","v":4},{"$f":"IF(J72=\"\",0,+J72)","v":{"v":1,"d":"1.00"}}]
[null,null,66,"Percentage of working supporting staff to no. of sanctioned posts (including Lab bearers, gas man etc..)",2,3,{"$f":"IF(E73=\"\",\"\",ROUND(E73/F73,4))","v":{"v":0.6667,"d":"66.6700%"}},3,{"v":1,"d":"1.00"},{"v":3,"d":"3.00"},{"$f":"IF($G73<$R73%,$K$5,\"\")","v":""},{"$f":"IF(AND($G73<$T73%,$G73>$Q73%),$L$5,\"\")","v":""},{"$f":"IF(AND($G73<$V73%,$G73>$S73%),$M$5,\"\")","v":""},{"$f":"IF(AND($G73<$X73%,$G73>$U73%),$N$5,\"\")","v":3},{"$f":"IF(AND($G73<Y73%,G73>W73%),$O$5,\"\")","v":""},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":3,"d":"3.00"}]
[null,null,{"$f":"1+C73","v":67},"Working accounts personnel","NO",null,{"$f":"+E74","v":"NO"},{"$f":"IF(E74=\"\",\"\",SUM(K74:O74))","v":0},{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"$f":"IF(OR(E74=\"\",E74=\"NO\"),$K$5,\"\")","v":0},{"$f":"IF(AND($G74<$T74%,$G74>$Q74%),$L$5,\"\")","v":""},{"$f":"IF(AND($G74<$V74%,$G74>$S74%),$M$5,\"\")","v":""},{"$f":"IF(AND($G74<$X74%,$G74>$U74%),$N$5,\"\")","v":""},{"$f":"IF(E74=\"YES\",$O$5,\"\")","v":""},{"$nulls":10},0,"NO",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"},{"$f":"SUM(BD72:BD74)","v":{"v":10,"d":"10.00"}},{"$f":"SUM(BE72:BE74)","v":{"v":4,"d":"4.00"}}]
["D. Student Support and participation","D-1 Learning Support",68,"Library facility","YES",null,{"$f":"+E75","v":"YES"},4,{"v":0.5,"d":"0.50"},{"$f":"IF(H75=\"\",\"\",+H75*I75*Z75)","v":{"v":2,"d":"2.00"}},{"$f":"IF(OR(E75=\"\",E75=\"NO\"),$K$5,\"\")","v":""},"","","",{"$f":"IF(E75=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,69,"Working Librarian","NO",null,{"$f":"+E76","v":"NO"},0,0.25,{"v":0,"d":"0.00"},{"$f":"IF(OR(E76=\"\",E76=\"NO\"),$K$5,\"\")","v":0},"","","",{"$f":"IF(E76=\"YES\",$O$5,\"\")","v":""},{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,70,"Whether library is automated","NO",null,{"$f":"+E77","v":"NO"},0,0.25,{"v":0,"d":"0.00"},{"$f":"IF(OR(E77=\"\",E77=\"NO\"),$K$5,\"\")","v":0},"","","",{"$f":"IF(E77=\"YES\",$O$5,\"\")","v":""},{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,71,"Percentage of working Library staff against sanctioned posts",null,0,{"$f":"IF(E78=\"\",\"\",ROUND(E78/F78,4))","v":""},{"$f":"IF(OR(E78=\"\",F78=\"\",F78=0),\"\",SUM(K78:O78))","v":""},0.25,"",{"$f":"IF($G78<$R78%,$K$5,\"\")","v":""},{"$f":"IF(AND($G78<$T78%,$G78>$Q78%),$L$5,\"\")","v":""},{"$f":"IF(AND($G78<$V78%,$G78>$S78%),$M$5,\"\")","v":""},{"$f":"IF(AND($G78<$X78%,$G78>$U78%),$N$5,\"\")","v":""},{"$f":"IF(AND($G78<Y78%,G78>W78%),$O$5,\"\")","v":""},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,0,{"$nulls":22},"",{"$nulls":4},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,72,"Ratio of total books in library to total No. of students",8833,{"$f":"+$E$7","v":84.66},{"$f":"IF(E79=\"\",\"\",ROUND(E79/F79,4))","v":{"v":104.335,"d":"104.3350"}},4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF($G79<$R79,$K$5,\"\")","v":""},{"$f":"IF(AND($G79<$T79,$G79>$Q79),$L$5,\"\")","v":""},{"$f":"IF(AND($G79<$V79,$G79>$S79),$M$5,\"\")","v":""},{"$f":"IF(AND($G79<$X79,$G79>$U79),$N$5,\"\")","v":""},{"$f":"IF(AND($G79<Y79,G79>W79),$O$5,\"\")","v":4},0,0.999,1,2.9999,3,3.9999,4,4.9999,5,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,73,"No. of Reading Rooms",0,null,{"$f":"+E80","v":0},{"$f":"IF(E80=\"\",\"\",SUM(K80:O80))","v":0},{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"$f":"IF($E80<$R80,$K$5,\"\")","v":0},null,{"$f":"IF(AND($E80<$V80,$E80>$S80),$M$5,\"\")","v":""},null,{"$f":"IF(AND($E80<Y80,E80>W80),$O$5,\"\")","v":""},0,0.999,0.999,0.999,1,1.9999,2,1.9999,2,10000,0,{"$nulls":27},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,74,"No. of copies of News papers subscribed per 100 students",0,{"$f":"+$E$7","v":84.66},{"$f":"IF(E81=\"\",\"\",ROUND(E81/(F81/100),4))","v":{"v":0,"d":"0.0000"}},{"$f":"IF(OR(E81=\"\",F81=\"\",F81=0),\"\",SUM(K81:O81))","v":0},0.25,{"v":0,"d":"0.00"},{"$f":"IF($G81<$R81,$K$5,\"\")","v":0},{"$f":"IF(AND($G81<$T81,$G81>$Q81),$L$5,\"\")","v":""},{"$f":"IF(AND($G81<$V81,$G81>$S81),$M$5,\"\")","v":""},{"$f":"IF(AND($G81<$X81,$G81>$U81),$N$5,\"\")","v":""},{"$f":"IF(AND($G81<Y81,G81>W81),$O$5,\"\")","v":""},0,0.999,1,1.9999,2,2.9999,3,3.9999,4,10000,0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,75,"Subscription of employment News paper","NO",null,{"$f":"+E82","v":"NO"},{"$f":"IF(E82=\"\",\"\",SUM(K82:O82))","v":0},0.25,{"v":0,"d":"0.00"},{"$f":"IF(OR(E82=\"\",E82=\"NO\"),$K$5,\"\")","v":0},{"$f":"IF(AND($G82<$T82%,$G82>$Q82%),$L$5,\"\")","v":""},{"$f":"IF(AND($G82<$V82%,$G82>$S82%),$M$5,\"\")","v":""},{"$f":"IF(AND($G82<$X82%,$G82>$U82%),$N$5,\"\")","v":""},{"$f":"IF(E82=\"YES\",$O$5,\"\")","v":""},{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,76,"No. of magazines subscribed",0,null,{"$f":"+E83","v":0},{"$f":"IF(E83=\"\",\"\",SUM(K83:O83))","v":0},0.25,{"v":0,"d":"0.00"},{"$f":"IF($E83<$R83,$K$5,\"\")","v":0},{"$f":"IF(AND($E83<$T83,$E83>$Q83),$L$5,\"\")","v":""},{"$f":"IF(AND($E83<$V83,$E83>$S83),$M$5,\"\")","v":""},{"$f":"IF(AND($E83<$X83,$E83>$U83),$N$5,\"\")","v":""},{"$f":"IF(AND($E83<Y83,E83>W83),$O$5,\"\")","v":""},0,0.999,1,3.9999,4,6.9999,7,9.9999,10,10000,0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,77,"Number of journals subscribed per subject",1,{"$f":"+$F$60","v":0},{"$f":"IF(E84=\"\",\"\",ROUND(E84/(F84/1),4))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E84=\"\",F84=\"\",F84=0),\"\",SUM(K84:O84))","v":""},{"v":0.5,"d":"0.50"},"",{"$f":"IF($G84<$R84,$K$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G84<$T84,$G84>$Q84),$L$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G84<$V84,$G84>$S84),$M$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G84<$X84,$G84>$U84),$N$5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($G84<Y84,G84>W84),$O$5,\"\")","v":{"$error":"#DIV/0!"}},0,0.999,1,1.9999,2,2.9999,3,3.9999,4,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"},{"$f":"SUM(BD75:BD84)","v":{"v":14,"d":"14.00"}},{"$f":"SUM(BE75:BE84)","v":{"v":4,"d":"4.00"}}]
["D. Student Support and participation","D-2 Counseling and Mentoring",78,"Percentage of Students guided through Counselling cell",0,{"$f":"+$E$7","v":84.66},{"$f":"IF(E85=\"\",\"\",ROUND(E85/F85,4))","v":{"v":0,"d":"0.0000%"}},0,0.25,{"v":0,"d":"0.00"},{"$f":"IF($G85<$R85%,$K$5,\"\")","v":0},{"$f":"IF(AND($G85<$T85%,$G85>$Q85%),$L$5,\"\")","v":""},{"$f":"IF(AND($G85<$V85%,$G85>$S85%),$M$5,\"\")","v":""},{"$f":"IF(AND($G85<$X85%,$G85>$U85%),$N$5,\"\")","v":""},{"$f":"IF(AND($G85<Y85%,G85>W85%),$O$5,\"\")","v":""},0,5e-05,1E-4,1.9999,2,3.9999,4,5.9999,6,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,79,"Sports Ground","YES",null,{"$f":"+E86","v":"YES"},{"$f":"IF(E86=\"\",\"\",SUM(K86:O86))","v":4},0.25,{"v":1,"d":"1.00"},{"$f":"IF(OR(E86=\"\",E86=\"NO\"),$K$5,\"\")","v":""},{"$f":"IF(AND($G86<$T86%,$G86>$Q86%),$L$5,\"\")","v":""},{"$f":"IF(AND($G86<$V86%,$G86>$S86%),$M$5,\"\")","v":""},{"$f":"IF(AND($G86<$X86%,$G86>$U86%),$N$5,\"\")","v":""},{"$f":"IF(E86=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,0.25,1,{"v":1,"d":"1.00"}]
[null,null,80,"Working Director Physical Education","NO",null,"NO",0,0.25,{"v":0,"d":"0.00"},{"$f":"IF(OR(E87=\"\",E87=\"NO\"),$K$5,\"\")","v":0},"","","",{"$f":"IF(E87=\"YES\",$O$5,\"\")","v":""},{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,81,"No. of games for which complete set of equipments and gears available",6,null,6,2,0.25,{"v":0.5,"d":"0.50"},{"$f":"IF($E88<$R88,$K$5,\"\")","v":""},{"$f":"IF(AND($E88<$T88,$E88>$Q88),$L$5,\"\")","v":""},{"$f":"IF(AND($E88<$V88,$E88>$S88),$M$5,\"\")","v":2},{"$f":"IF(AND($E88<$X88,$E88>$U88),$N$5,\"\")","v":""},{"$f":"IF(AND($E88<Y88,E88>W88),$O$5,\"\")","v":""},0,2.9999,3,3.9999,4,6.9999,7,9.9999,10,10000,1,"YES",{"$nulls":26},4,0.25,1,{"v":0.5,"d":"0.50"}]
[null,null,82,"Total No. of students benefited by issuing of sports equipments and gears",80,null,80,2,0.25,{"v":0.5,"d":"0.50"},{"$f":"IF($E89<$R89,$K$5,\"\")","v":""},{"$f":"IF(AND($E89<$T89,$E89>$Q89),$L$5,\"\")","v":""},{"$f":"IF(AND($E89<$V89,$E89>$S89),$M$5,\"\")","v":2},{"$f":"IF(AND($E89<$X89,$E89>$U89),$N$5,\"\")","v":""},{"$f":"IF(AND($E89<Y89,E89>W89),$O$5,\"\")","v":""},0,5e-05,1E-4,49.9999,50,99.9999,100,199.9999,200,10000,1,"YES",{"$nulls":26},4,0.25,1,{"v":0.5,"d":"0.50"}]
[null,null,83,"No. of events at Inter-college / University / National and International level in which college participated",5,null,5,1,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},{"$f":"IF($E90<$R90,$K$5,\"\")","v":""},{"$f":"IF(AND($E90<$T90,$E90>$Q90),$L$5,\"\")","v":1},{"$f":"IF(AND($E90<$V90,$E90>$S90),$M$5,\"\")","v":""},{"$f":"IF(AND($E90<$X90,$E90>$U90),$N$5,\"\")","v":""},{"$f":"IF(AND($E90<Y90,E90>W90),$O$5,\"\")","v":""},0,0.9999,1,5.9999,6,10.9999,11,15.9999,16,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":0.5,"d":"0.50"}]
[null,null,84,"No. of prizes won by college at Inter-college / University  /National and International sports/ games",6,null,6,3,0.25,0.75,{"$f":"IF($E91<$R91,$K$5,\"\")","v":""},{"$f":"IF(AND($E91<$T91,$E91>$Q91),$L$5,\"\")","v":""},{"$f":"IF(AND($E91<$V91,$E91>$S91),$M$5,\"\")","v":""},{"$f":"IF(AND($E91<$X91,$E91>$U91),$N$5,\"\")","v":3},{"$f":"IF(AND($E91<Y91,E91>W91),$O$5,\"\")","v":""},0,0.9999,1,2.9999,3,5.9999,6,8.9999,9,10000,1,"YES",{"$nulls":26},4,0.25,1,0.75]
[null,null,85,"Anti ragging cell","YES",null,"YES",4,0.25,{"v":1,"d":"1.00"},{"$f":"IF(OR(E92=\"\",E92=\"NO\"),$K$5,\"\")","v":""},{"$f":"IF(AND($G92<$T92%,$G92>$Q92%),$L$5,\"\")","v":""},{"$f":"IF(AND($G92<$V92%,$G92>$S92%),$M$5,\"\")","v":""},{"$f":"IF(AND($G92<$X92%,$G92>$U92%),$N$5,\"\")","v":""},{"$f":"IF(E92=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,0.25,1,{"v":1,"d":"1.00"}]
[null,null,86,"Women cell","YES",null,"YES",4,0.25,{"v":1,"d":"1.00"},{"$f":"IF(OR(E93=\"\",E93=\"NO\"),$K$5,\"\")","v":""},"","","",{"$f":"IF(E93=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,0.25,1,{"v":1,"d":"1.00"}]
[null,null,87,"Sexual harassment complaint cell","YES",null,"YES",4,0.25,{"v":1,"d":"1.00"},{"$f":"IF(OR(E94=\"\",E94=\"NO\"),$K$5,\"\")","v":""},"","","",{"$f":"IF(E94=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,0.25,1,{"v":1,"d":"1.00"}]
["D. Student Support and participation","D-2 Counseling and Mentoring",88,"Total No. of Extra-curricular activities organised",10,null,10,2,{"v":0.5,"d":"0.50"},{"v":1,"d":"1.00"},{"$f":"IF($E95<$R95,$K$5,\"\")","v":""},{"$f":"IF(AND($E95<$T95,$E95>$Q95),$L$5,\"\")","v":""},{"$f":"IF(AND($E95<$V95,$E95>$S95),$M$5,\"\")","v":2},{"$f":"IF(AND($E95<$X95,$E95>$U95),$N$5,\"\")","v":""},{"$f":"IF(AND($E95<Y95,E95>W95),$O$5,\"\")","v":""},0,0.9999,1,5.9999,6,10.9999,11,15.9999,16,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":1,"d":"1.00"}]
[null,null,89,"Is Remedial coaching facility being provided","NO",null,"NO",0,0.25,{"v":0,"d":"0.00"},{"$f":"IF(OR(E96=\"\",E96=\"NO\"),$K$5,\"\")","v":0},{"$f":"IF(AND($G96<$T96%,$G96>$Q96%),$L$5,\"\")","v":""},{"$f":"IF(AND($G96<$V96%,$G96>$S96%),$M$5,\"\")","v":""},{"$f":"IF(AND($G96<$X96%,$G96>$U96%),$N$5,\"\")","v":""},{"$f":"IF(E96=\"YES\",$O$5,\"\")","v":""},{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,90,"Percentage of Students utilising IT / ICT lab. Facility to total No. of students",70,{"$f":"+$E$7","v":84.66},{"$f":"IF(E97=\"\",\"\",ROUND(E97/F97,4))","v":{"v":0.8268,"d":"82.6800%"}},{"$f":"IF(OR(E97=\"\",F97=\"\",F97=0),\"\",SUM(K97:O97))","v":4},0.25,{"v":1,"d":"1.00"},{"$f":"IF($G97<$R97%,$K$5,\"\")","v":""},{"$f":"IF(AND($G97<$T97%,$G97>$Q97%),$L$5,\"\")","v":""},{"$f":"IF(AND($G97<$V97%,$G97>$S97%),$M$5,\"\")","v":""},{"$f":"IF(AND($G97<$X97%,$G97>$U97%),$N$5,\"\")","v":""},{"$f":"IF(AND($G97<Y97%,G97>W97%),$O$5,\"\")","v":4},0,5e-05,1E-4,4.9999,5,9.9999,10,14.9999,15,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,0.25,1,{"v":1,"d":"1.00"}]
[null,null,91,"Entrepreneurship / Skill Development promotional cell in the college","NO",null,{"$f":"+E98","v":"NO"},{"$f":"IF(E98=\"\",\"\",SUM(K98:O98))","v":0},0.25,{"v":0,"d":"0.00"},{"$f":"IF(OR(E98=\"\",E98=\"NO\"),$K$5,\"\")","v":0},{"$f":"IF(AND($G98<$T98%,$G98>$Q98%),$L$5,\"\")","v":""},{"$f":"IF(AND($G98<$V98%,$G98>$S98%),$M$5,\"\")","v":""},{"$f":"IF(AND($G98<$X98%,$G98>$U98%),$N$5,\"\")","v":""},{"$f":"IF(E98=\"YES\",$O$5,\"\")","v":""},{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,92,"NSS units in the college","YES",null,"YES",4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},"","","","",4,{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,93,"Rover/ Ranger unit","NO",null,"NO",0,0.25,{"v":0,"d":"0.00"},0,"","","","",{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,94,"NCC unit in the college","NO",null,"NO",0,0.25,{"v":0,"d":"0.00"},0,"","","","",{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,95,"Employment/ job vacancy display board for students","NO",null,"NO",0,0.25,{"v":0,"d":"0.00"},0,"","","","",{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,96,"First-Aid kit available","YES",null,"YES",4,0.25,{"v":1,"d":"1.00"},"","","","",4,{"$nulls":10},1,"YES",{"$nulls":26},4,0.25,1,{"v":1,"d":"1.00"}]
[null,null,97,"Functional Fire Extinguishers available","YES",null,"YES",4,0.25,{"v":1,"d":"1.00"},"","","","",4,{"$nulls":10},1,"YES",{"$nulls":26},4,0.25,1,{"v":1,"d":"1.00"}]
[null,null,98,"Students suggestion / feedback box available","YES",null,"YES",4,0.25,{"v":1,"d":"1.00"},"","","","",4,{"$nulls":10},1,"YES",{"$nulls":26},4,0.25,1,{"v":1,"d":"1.00"}]
["D. Student Support and participation","D-2 Counseling and Mentoring",99,"Canteen facility available","NO",null,"NO",0,0.25,{"v":0,"d":"0.00"},0,"","","","",{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"}]
[null,null,100,"Hostel facility available","NO",null,"NO",0,0.25,{"v":0,"d":"0.00"},0,"","","","",{"$nulls":10},0,{"$nulls":27},4,0.25,1,{"v":0,"d":"0.00"},{"$f":"SUM(BD85:BD107)","v":{"v":26,"d":"26.00"}},{"$f":"SUM(BE85:BE107)","v":13.25}]
["E. Financial Resources and Utilisation","E-1 Financial Management",101,"Percentage of total grants utilized in last 3 years",100,100,{"$f":"IF(E108=\"\",\"\",ROUND(E108/F108,4))","v":{"v":1,"d":"100.0000%"}},{"$f":"IF(OR(E108=\"\",F108=\"\",F108=0),\"\",SUM(K108:O108))","v":4},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"},{"$f":"IF($G108<$R108%,$K$5,\"\")","v":""},{"$f":"IF(AND($G108<$T108%,$G108>$Q108%),$L$5,\"\")","v":""},{"$f":"IF(AND($G108<$V108%,$G108>$S108%),$M$5,\"\")","v":""},{"$f":"IF(AND($G108<$X108%,$G108>$U108%),$N$5,\"\")","v":""},{"$f":"IF(AND($G108<Y108%,G108>W108%),$O$5,\"\")","v":4},0,19.9999,20,39.9999,40,59.9999,60,79.9999,80,10000,1,"YES",{"$nulls":21},{"$f":"IF(E108>F108,\"ERROR INPUT\",\"\")","v":""},{"$nulls":4},4,{"v":2,"d":"2.00"},8,{"v":8,"d":"8.00"}]
[null,null,102,"Average annual per capita capital expenditure",90,{"$f":"+$E$7","v":84.66},{"$f":"IF(E109=\"\",\"\",ROUND(E109/F109,4))","v":{"v":1.0631,"d":"106.3100%"}},{"$f":"IF(E109=\"\",\"\",SUM(K109:O109))","v":1},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"$f":"IF($G109<$R109,$K$5,\"\")","v":""},{"$f":"IF(AND($G109<$T109,$G109>$Q109),$L$5,\"\")","v":1},{"$f":"IF(AND($G109<$V109,$G109>$S109),$M$5,\"\")","v":""},{"$f":"IF(AND($G109<$X109,$G109>$U109),$N$5,\"\")","v":""},{"$f":"IF(AND($G109<Y109,G109>W109),$O$5,\"\")","v":""},0,5e-05,1E-4,499.9999,500,999.9999,1000,1499.9999,1500,100000000,1,"YES",{"$nulls":26},4,{"v":2,"d":"2.00"},8,{"v":2,"d":"2.00"}]
[null,null,103,"Average annual per capita operational expenditure",90,{"$f":"+$E$7","v":84.66},{"$f":"IF(E110=\"\",\"\",ROUND(E110/F110,4))","v":{"v":1.0631,"d":"106.3100%"}},0,{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"$f":"IF($G110<$R110,$K$5,\"\")","v":0},{"$f":"IF(AND($G110<$T110,$G110>$Q110),$L$5,\"\")","v":""},{"$f":"IF(AND($G110<$V110,$G110>$S110),$M$5,\"\")","v":""},{"$f":"IF(AND($G110<$X110,$G110>$U110),$N$5,\"\")","v":""},{"$f":"IF(AND($G110<Y110,G110>W110),$O$5,\"\")","v":""},0,199.9999,200,399.9999,400,599.9999,600,799.9999,800,100000000,1,"YES",{"$nulls":26},4,{"v":2,"d":"2.00"},8,{"v":0,"d":"0.00"}]
[null,null,104,"No. of Internal/ CA Audits undertaken during last 3 years",null,null,{"$f":"+E111","v":0},"",{"v":2,"d":"2.00"},"",{"$f":"IF($E111<$R111,$K$5,\"\")","v":0},{"$f":"IF(AND($E111<$T111,$E111>$Q111),$L$5,\"\")","v":""},{"$f":"IF(AND($E111<$V111,$E111>$S111),$M$5,\"\")","v":""},{"$f":"IF(AND($E111<$X111,$E111>$U111),$N$5,\"\")","v":""},{"$f":"IF(AND($E111<Y111,E111>W111),$O$5,\"\")","v":""},0,0.9999,1,1.9999,2,2.9999,3,3.9999,4,10000,0,"NO",{"$nulls":26},4,{"v":2,"d":"2.00"},8,{"v":0,"d":"0.00"},{"$f":"SUM(BD108:BD111)","v":{"v":32,"d":"32.00"}},{"$f":"SUM(BE108:BE111)","v":{"v":10,"d":"10.00"}}]
[null,"E-2 Self Financing Efforts",105,"Funds received from sources other than state or central govt (last 03 years)",0,null,0,0,{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},0,"","","","",0,0.9999,1,{"$f":"-0.1+100000","v":99999.9},100000,{"$f":"-0.1+600000","v":599999.9},600000,{"$f":"-0.1+2000000","v":1999999.9},2000000,1000000000,0,"NO",{"$nulls":26},4,{"v":2,"d":"2.00"},8,{"v":0,"d":"0.00"},{"$f":"+BD112","v":8},{"$f":"+BE112","v":0}]
["F. Commitment, Leadership and Management","F-1 Societal Footprint",106,"Progress made under Green campus initiative (No. Of activities)",1,null,1,1,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},"",1,"","","",0,0.9999,1,3.99999,4,6.9999,7,9.9999,10,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":0.5,"d":"0.50"}]
[null,null,107,"No. of efforts undertaken for creating national integration and Community awareness among students",3,null,3,1,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},"",1,"","","",0,0.9999,1,3.99999,4,6.9999,7,9.9999,10,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":0.5,"d":"0.50"}]
[null,null,108,"No. of Institutional/ Corporate Collaborative activities undertaken",0,null,0,0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},0,"","","","",0,0.9999,1,1.9999,2,2.9999,3,3.9999,4,10000,0,{"$nulls":27},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"},{"$f":"SUM(BD113:BD115)","v":{"v":6,"d":"6.00"}},{"$f":"SUM(BE113:BE115)","v":{"v":1,"d":"1.00"}}]
["F. Commitment, Leadership and Management","F-2 Innovatin, Values and Best practices",109,"No. of initiatives undertaken for Students welfare",0,null,0,0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},0,"","","","",0,0.9999,1,1.9999,2,2.9999,3,3.9999,4,10000,0,{"$nulls":27},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,110,"Faculty Development Initiatives",1,null,1,1,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},"",1,"","","",0,0.9999,1,1.9999,2,2.9999,3,3.9999,4,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":0.5,"d":"0.50"}]
[null,null,111,"No. Of Books collected under Community Book Bank scheme",20,null,20,1,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},"",1,"","","",0,0.9999,1,100.00001,101,200.0001,201,499.9999,500,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":0.5,"d":"0.50"}]
[null,null,112,"Participation of college in District level campaigning/ activities organized by district administration",0,null,0,0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},0,"","","","",0,0.9999,1,2.9999,3,4.9999,5,6.9999,7,10000,0,{"$nulls":27},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,113,"Any other best/ unique performance/ activity/ social contribution","YES",null,"YES",4,{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"$f":"IF(OR(E120=\"\",E120=\"NO\"),$K$5,\"\")","v":""},{"$f":"IF(AND($G120<$T120%,$G120>$Q120%),$L$5,\"\")","v":""},{"$f":"IF(AND($G120<$V120%,$G120>$S120%),$M$5,\"\")","v":""},{"$f":"IF(AND($G120<$X120%,$G120>$U120%),$N$5,\"\")","v":""},{"$f":"IF(E120=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":1,"d":"1.00"},4,{"v":4,"d":"4.00"}]
[null,null,114,"Percentage of students participating in Inter House sport activities",80,{"$f":"+$E$7","v":84.66},{"$f":"IF(E121=\"\",\"\",ROUND(E121/F121,4))","v":{"v":0.945,"d":"94.5000%"}},{"$f":"IF(OR(E121=\"\",F121=\"\",F121=0),\"\",SUM(K121:O121))","v":4},{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF($G121<$R121%,$K$5,\"\")","v":""},{"$f":"IF(AND($G121<$T121%,$G121>$Q121%),$L$5,\"\")","v":""},{"$f":"IF(AND($G121<$V121%,$G121>$S121%),$M$5,\"\")","v":""},{"$f":"IF(AND($G121<$X121%,$G121>$U121%),$N$5,\"\")","v":""},{"$f":"IF(AND($G121<Y121%,G121>W121%),$O$5,\"\")","v":4},0,5e-05,1E-4,9.9999,10,19.9999,20,29.9999,30,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,115,"Is there any formal mechanism for Student feedback in place ?","NO",null,{"$f":"+E122","v":"NO"},{"$f":"IF(E122=\"\",\"\",SUM(K122:O122))","v":0},{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"$f":"IF(OR(E122=\"\",E122=\"NO\"),$K$5,\"\")","v":0},{"$f":"IF(AND($G122<$T122%,$G122>$Q122%),$L$5,\"\")","v":""},{"$f":"IF(AND($G122<$V122%,$G122>$S122%),$M$5,\"\")","v":""},{"$f":"IF(AND($G122<$X122%,$G122>$U122%),$N$5,\"\")","v":""},{"$f":"IF(E122=\"YES\",$O$5,\"\")","v":""},{"$nulls":10},0,{"$nulls":27},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,116,"Whether the college has functional solar power generating system","YES",null,{"$f":"+E123","v":"YES"},4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF(OR(E123=\"\",E123=\"NO\"),$K$5,\"\")","v":""},"","","",{"$f":"IF(E123=\"YES\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"},{"$f":"SUM(BD116:BD123)","v":{"v":18,"d":"18.00"}},{"$f":"SUM(BE116:BE123)","v":{"v":9,"d":"9.00"}}]
[null,"F-3 Effective Implementatin of Govt. Schemes",117,"Implementation of Scholarships / Incentive schemes (distributional efficacy)","No Pendency",null,{"$f":"+E124","v":"No Pendency"},4,{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"$f":"IF(OR(E124=\"\",E124=\"YES PENDENCY\"),$K$5,\"\")","v":""},"","","",{"$f":"IF(E124=\"NO PENDENCY\",$O$5,\"\")","v":4},{"$nulls":10},1,"YES",{"$nulls":26},4,{"v":1,"d":"1.00"},4,{"v":4,"d":"4.00"}]
[null,null,118,"Percentage of students placed through Employment fairs organised by the college",0,{"$f":"+$E$7","v":84.66},{"$f":"IF(E125=\"\",\"\",ROUND(E125/F125,4))","v":{"v":0,"d":"0.0000%"}},{"$f":"IF(OR(E125=\"\",F125=\"\",F125=0),\"\",SUM(K125:O125))","v":0},{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"$f":"IF($G125<$R125%,$K$5,\"\")","v":0},{"$f":"IF(AND($G125<$T125%,$G125>$Q125%),$L$5,\"\")","v":""},{"$f":"IF(AND($G125<$V125%,$G125>$S125%),$M$5,\"\")","v":""},{"$f":"IF(AND($G125<$X125%,$G125>$U125%),$N$5,\"\")","v":""},{"$f":"IF(AND($G125<Y125%,G125>W125%),$O$5,\"\")","v":""},0,5e-05,1E-4,1.9999,2,3.9999,4,5.9999,6,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,119,"Percentage of students who received GK Books",80,{"$f":"+$E$7","v":84.66},{"v":0.945,"d":"94.5000%"},4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF($G126<$R126%,$K$5,\"\")","v":""},{"$f":"IF(AND($G126<$T126%,$G126>$Q126%),$L$5,\"\")","v":""},{"$f":"IF(AND($G126<$V126%,$G126>$S126%),$M$5,\"\")","v":""},{"$f":"IF(AND($G126<$X126%,$G126>$U126%),$N$5,\"\")","v":""},{"$f":"IF(AND($G126<Y126%,G126>W126%),$O$5,\"\")","v":4},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
["F. Commitment, Leadership and Management","F-3 Effective Implementatin of Govt. Schemes",120,"Percentage of students who received English Grammar Books",80,84.66,{"$f":"IF(E127=\"\",\"\",ROUND(E127/F127,4))","v":{"v":0.945,"d":"94.5000%"}},4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},{"$f":"IF($G127<$R127%,$K$5,\"\")","v":""},{"$f":"IF(AND($G127<$T127%,$G127>$Q127%),$L$5,\"\")","v":""},{"$f":"IF(AND($G127<$V127%,$G127>$S127%),$M$5,\"\")","v":""},{"$f":"IF(AND($G127<$X127%,$G127>$U127%),$N$5,\"\")","v":""},{"$f":"IF(AND($G127<Y127%,G127>W127%),$O$5,\"\")","v":4},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":2,"d":"2.00"}]
[null,null,121,"Classes organized under Pratiyogita Dakshta Programme [{(Actual No. of Classes)/ (4*No. of days)}*100 ]",null,null,{"$f":"IF(E128=\"\",\"\",ROUND(E128/(4*F128),4)*100)","v":""},"",{"v":1,"d":"1.00"},"",{"$f":"IF($G128<$R128,$K$5,\"\")","v":""},{"$f":"IF(AND($G128<$T128,$G128>$Q128),$L$5,\"\")","v":""},{"$f":"IF(AND($G128<$V128,$G128>$S128),$M$5,\"\")","v":""},{"$f":"IF(AND($G128<$X128,$G128>$U128),$N$5,\"\")","v":""},{"$f":"IF(AND($G128<Y128,G128>W128),$O$5,\"\")","v":""},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":1,"d":"1.00"},4,{"v":0,"d":"0.00"}]
[null,null,122,"Percentage of Students who appeared in State Level GK Competition",0,{"$f":"+$E$7","v":84.66},{"$f":"IF(E129=\"\",\"\",ROUND(E129/F129,4))","v":{"v":0,"d":"0.0000%"}},0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"$f":"IF($G129<$R129%,$K$5,\"\")","v":0},{"$f":"IF(AND($G129<$T129%,$G129>$Q129%),$L$5,\"\")","v":""},{"$f":"IF(AND($G129<$V129%,$G129>$S129%),$M$5,\"\")","v":""},{"$f":"IF(AND($G129<$X129%,$G129>$U129%),$N$5,\"\")","v":""},{"$f":"IF(AND($G129<Y129%,G129>W129%),$O$5,\"\")","v":""},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,0,{"$nulls":22},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,123,"No. of trees planted",430,null,{"$f":"+E130","v":430},{"$f":"IF(E130=\"\",\"\",SUM(K130:O130))","v":4},{"v":1.5,"d":"1.50"},{"v":6,"d":"6.00"},{"$f":"IF($E130<$R130,$K$5,\"\")","v":""},{"$f":"IF(AND($E130<$T130,$E130>$Q130),$L$5,\"\")","v":""},{"$f":"IF(AND($E130<$V130,$E130>$S130),$M$5,\"\")","v":""},{"$f":"IF(AND($E130<$X130,$E130>$U130),$N$5,\"\")","v":""},{"$f":"IF(AND($E130<Y130,E130>W130),$O$5,\"\")","v":4},0,10.0001,11,50.0001,51,100.0001,101,200.0001,201,10000,1,"YES",{"$nulls":26},4,{"v":1.5,"d":"1.50"},6,{"v":6,"d":"6.00"}]
[null,null,124,"Average Percentage of Students who turned up for Monthly Test",40,{"$f":"+$E$7","v":84.66},{"$f":"IF(E131=\"\",\"\",ROUND(E131/F131,4))","v":{"v":0.4725,"d":"47.2500%"}},{"$f":"IF(OR(E131=\"\",F131=\"\",F131=0),\"\",SUM(K131:O131))","v":2},{"v":0.5,"d":"0.50"},{"v":1,"d":"1.00"},{"$f":"IF($G131<$R131%,$K$5,\"\")","v":""},{"$f":"IF(AND($G131<$T131%,$G131>$Q131%),$L$5,\"\")","v":""},{"$f":"IF(AND($G131<$V131%,$G131>$S131%),$M$5,\"\")","v":2},{"$f":"IF(AND($G131<$X131%,$G131>$U131%),$N$5,\"\")","v":""},{"$f":"IF(AND($G131<Y131%,G131>W131%),$O$5,\"\")","v":""},0,19.999,20,39.999,40,59.999,60,79.999,80,10000,1,"YES",{"$nulls":21},"",{"$nulls":4},4,{"v":0.5,"d":"0.50"},2,{"v":1,"d":"1.00"},{"$f":"SUM(BD124:BD131)","v":{"v":24,"d":"24.00"}},{"$f":"SUM(BE124:BE131)","v":{"v":15,"d":"15.00"}}]
[null,"F-4 Strengthening the bond",125,"No. of Interactive sessions organised for students with motivational mentors/ excellent performers",2,null,{"$f":"+E132","v":2},{"$f":"IF(E132=\"\",\"\",SUM(K132:O132))","v":2},{"v":0.5,"d":"0.50"},{"v":1,"d":"1.00"},{"$f":"IF($E132<$R132,$K$5,\"\")","v":""},{"$f":"IF(AND($E132<$T132,$E132>$Q132),$L$5,\"\")","v":""},{"$f":"IF(AND($E132<$V132,$E132>$S132),$M$5,\"\")","v":2},{"$f":"IF(AND($E132<$X132,$E132>$U132),$N$5,\"\")","v":""},{"$f":"IF(AND($E132<Y132,E132>W132),$O$5,\"\")","v":""},0,0.9999,1,1.9999,2,2.9999,3,3.9999,4,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":1,"d":"1.00"}]
[null,null,126,"No. of Students- Principal interactions",0,null,0,0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},0,"","","","",0,0.9999,1,1.9999,2,2.9999,3,3.9999,4,10000,0,{"$nulls":27},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,127,"No. of Student- Teacher meetings other than class teaching",0,null,0,0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},0,"","","","",0,0.9999,1,1.9999,2,2.9999,3,3.9999,4,10000,0,{"$nulls":27},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"}]
[null,null,128,"No. of Staff Council and Development committee meetings held",2,null,2,2,{"v":0.5,"d":"0.50"},{"v":1,"d":"1.00"},"","",2,"","",0,0.9999,1,1.9999,2,2.9999,3,3.9999,4,10000,1,"YES",{"$nulls":26},4,{"v":0.5,"d":"0.50"},2,{"v":1,"d":"1.00"}]
[null,null,129,"No. of Parents- Teacher meetings",4,null,4,4,{"v":0.5,"d":"0.50"},{"v":2,"d":"2.00"},"","","","",4,0,0.9999,1,1.9999,2,2.9999,3,3.9999,4,10000,{"$f":"IF(AA136=\"YES\",1,0)*IF(AW136=\"ERROR INPUT\",0,1)","v":1},"YES",{"$nulls":26},4,{"$f":"+I136","v":{"v":0.5,"d":"0.50"}},{"$f":"+BB136*BC136","v":2},{"$f":"IF(J136=\"\",0,+J136)","v":{"v":2,"d":"2.00"}}]
[null,null,130,"No. of Alumni meetings held (last two years)",0,null,0,0,{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},0,"","","","",0,0.9999,1,1.9999,2,2.9999,3,3.9999,4,10000,0,{"$nulls":27},4,{"v":0.5,"d":"0.50"},2,{"v":0,"d":"0.00"},{"$f":"SUM(BD132:BD137)","v":{"v":12,"d":"12.00"}},{"$f":"SUM(BE132:BE137)","v":{"v":4,"d":"4.00"}}]

{"sheet":"Result KeyFactorwise","index":3,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[4,0,8,0],[9,0,10,0],[11,0,12,0],[13,0,14,0],[15,0,16,0],[17,0,20,0]]}
[{"$f":"+Result!B1","v":"SHRI SHIV CHARAN MATHUR, GOVERNMENT COLLEGE, MANDALGARH"}]
["Assessment Matrix for Annual Auditing Programe"]
[{"$f":"+Result!B3","v":"Session : 2019-20"}]
["Crteria","Key Factors Criteria","Maximum Weighted Credits","Actual Weighted Credits","Percentage of Actual with Maximum",null,"Delete Input Values Key Factor "]
["A. Teaching  and  Learning","A-1 Student Strength",{"$f":"IF(D5=0,\"\",Input!BF8)","v":""},{"$f":"Input!BG8","v":{"v":0,"d":"0.00"}},{"$f":"IF(D5=0,\"\",ROUND(D5/C5*100,2))","v":""}]
[null,"A-2 Inclusivity",{"$f":"IF(D6=0,\"\",Input!BF19)","v":{"v":36,"d":"36.00"}},{"$f":"Input!BG19","v":{"v":25.5,"d":"25.50"}},{"v":70.83,"d":"70.830"}]
[null,"A-3 Choices",{"$f":"IF(D7=0,\"\",Input!BF25)","v":{"v":22,"d":"22.00"}},{"$f":"Input!BG25","v":{"v":10.5,"d":"10.50"}},{"v":47.73,"d":"47.730"}]
[null,"A-4 Faculty-Portrayal",{"$f":"IF(D8=0,\"\",Input!BF34)","v":{"v":36,"d":"36.00"}},{"$f":"Input!BG34","v":{"v":13.5,"d":"13.50"}},{"v":37.5,"d":"37.500"}]
[null,"A-5 Student performance and learning outcomes",{"$f":"IF(D9=0,\"\",Input!BF37)","v":""},{"$f":"Input!BG37","v":{"v":0,"d":"0.00"}},""]
["B. Research and Professional Practices","B-1 Research Output",{"$f":"IF(D10=0,\"\",Input!BF47)","v":""},{"$f":"Input!BG47","v":{"v":0,"d":"0.00"}},""]
[null,"B-2 Academic Enrichment",{"$f":"IF(D11=0,\"\",Input!BF50)","v":""},{"$f":"Input!BG50","v":{"v":0,"d":"0.00"}},""]
["C. Infrastructure and Learning Resources","C-1 Physical Assets",{"$f":"IF(D12=0,\"\",Input!BF71)","v":{"v":50,"d":"50.00"}},{"$f":"Input!BG71","v":{"v":39.5,"d":"39.50"}},{"v":79,"d":"79.000"},null,"C"]
[null,"C-2 Office Setup",{"$f":"IF(D13=0,\"\",Input!BF74)","v":{"v":10,"d":"10.00"}},{"$f":"Input!BG74","v":{"v":4,"d":"4.00"}},{"v":40,"d":"40.000"}]
["D. Student Support and participation","D-1 Learning Support",{"$f":"IF(D14=0,\"\",Input!BF84)","v":{"v":14,"d":"14.00"}},{"$f":"Input!BG84","v":{"v":4,"d":"4.00"}},{"v":28.57,"d":"28.570"},null,"D"]
[null,"D-2 Counseling and Mentoring",{"$f":"IF(D15=0,\"\",Input!BF107)","v":{"v":26,"d":"26.00"}},{"$f":"Input!BG107","v":13.25},{"v":50.96,"d":"50.960"}]
["E. Financial Resources and Utilisation","E-1 Financial Management",{"$f":"IF(D16=0,\"\",Input!BF111)","v":{"v":32,"d":"32.00"}},{"$f":"Input!BG111","v":{"v":10,"d":"10.00"}},{"v":31.25,"d":"31.250"}]
[null,"E-2 Self Financing Efforts",{"$f":"IF(D17=0,\"\",Input!BF112)","v":""},{"$f":"Input!BG112","v":{"v":0,"d":"0.00"}},""]
["F. Commitment, Leadership and Management","F-1 Societal Footprint",{"$f":"IF(D18=0,\"\",Input!BF115)","v":{"v":6,"d":"6.00"}},{"$f":"Input!BG115","v":{"v":1,"d":"1.00"}},{"v":16.67,"d":"16.670"}]
[null,"F-2 Innovatin, Values and Best practices",{"$f":"IF(D19=0,\"\",Input!BF123)","v":{"v":18,"d":"18.00"}},{"$f":"Input!BG123","v":{"v":9,"d":"9.00"}},{"v":50,"d":"50.000"}]
[null,"F-3 Effective Implementatin of Govt. Schemes",{"$f":"IF(D20=0,\"\",Input!BF131)","v":{"v":24,"d":"24.00"}},{"$f":"Input!BG131","v":{"v":15,"d":"15.00"}},{"v":62.5,"d":"62.500"}]
[null,"F-4 Strengthening the bond",{"$f":"IF(D21=0,\"\",Input!BF137)","v":{"v":12,"d":"12.00"}},{"$f":"Input!BG137","v":{"v":4,"d":"4.00"}},{"v":33.33,"d":"33.330"}]
[null,"TOTAL",{"$f":"IF(SUM(C5:C21)=0,\"\",SUM(C5:C21))","v":{"v":286,"d":"286.00"}},{"$f":"IF(SUM(D5:D21)=0,\"\",SUM(D5:D21))","v":149.25}]
[null,"Average",{"$f":"IF(C22=\"\",\"\",ROUND(C22/4,2))","v":{"v":71.5,"d":"71.50"}},{"$f":"IF(D22=\"\",\"\",ROUND(D22/4,4))","v":{"v":37.3125,"d":"37.31"}}]

{"sheet":"Result","index":4,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,4]]}
[null,{"$f":"+'Result NAAC'!B1:F1","v":"SHRI SHIV CHARAN MATHUR, GOVERNMENT COLLEGE, MANDALGARH"}]
[null,"Assessment Matrix for Annual Auditing Programe"]
[null,"Session : 2019-20"]
[null,"Performance Criteria","Maximum Weighted Credits","Actual Weighted Credits","Percentage of Actual with Maximum",{"$nulls":3},"Delete Input Values Performance Criteria"]
[null,{"$f":"+Input!A7","v":"A. Teaching and Learning"},{"$f":"IF(D5=\"\",\"\",35*4)","v":{"v":140,"d":"140.00"}},{"$f":"IF(SUM(Input!J7:J37)=0,\"\",SUM(Input!J7:J37))","v":{"v":49.5,"d":"49.50"}},{"$f":"IF(D5=\"\",\"\",ROUND(D5/C5*100,2))","v":{"v":35.36,"d":"35.360"}},{"$nulls":3},"A"]
[null,{"$f":"+Input!A38","v":"B. Research and Professional Practices"},{"$f":"IF(D6=\"\",\"\",15*4)","v":""},{"$f":"IF(SUM(Input!J38:J50)=0,\"\",SUM(Input!J38:J50))","v":""},"",{"$nulls":3},"B"]
[null,{"$f":"+Input!A51","v":"C. Infrastructure and Learning Resources"},{"$f":"IF(D7=\"\",\"\",15*4)","v":{"v":60,"d":"60.00"}},{"$f":"IF(SUM(Input!J51:J74)=0,\"\",SUM(Input!J51:J74))","v":{"v":43.5,"d":"43.50"}},{"v":72.5,"d":"72.500"},{"$nulls":3},"C"]
[null,{"$f":"+Input!A75","v":"D. Student Support and participation"},{"$f":"IF(D8=\"\",\"\",10*4)","v":{"v":40,"d":"40.00"}},{"$f":"IF(SUM(Input!J75:J107)=0,\"\",SUM(Input!J75:J107))","v":17.25},{"v":43.13,"d":"43.130"},{"$nulls":3},"D"]
[null,{"$f":"+Input!A108","v":"E. Financial Resources and Utilisation"},{"$f":"IF(D9=\"\",\"\",10*4)","v":{"v":40,"d":"40.00"}},{"$f":"IF(SUM(Input!J108:J112)=0,\"\",SUM(Input!J108:J112))","v":{"v":10,"d":"10.00"}},{"v":25,"d":"25.000"},{"$nulls":3},"E"]
[null,{"$f":"+Input!A113","v":"F. Commitment, Leadership and Management"},{"$f":"IF(D10=\"\",\"\",15*4)","v":{"v":60,"d":"60.00"}},{"$f":"IF(SUM(Input!J113:J137)=0,\"\",SUM(Input!J113:J137))","v":{"v":29,"d":"29.00"}},{"v":48.33,"d":"48.330"},{"$nulls":3},"F"]
[null,"TOTAL",{"$f":"IF(SUM(C5:C10)=0,\"\",SUM(C5:C10))","v":{"v":340,"d":"340.00"}},{"$f":"IF(SUM(D5:D10)=0,\"\",SUM(D5:D10))","v":149.25}]
[null,"Average",{"$f":"IF(C11=\"\",\"\",ROUND(C11/4,2))","v":{"v":85,"d":"85.00"}},{"$f":"IF(D11=\"\",\"\",ROUND(D11/4,4))","v":{"v":37.3125,"d":"37.31"}}]